Questions tagged as 'stored-procedures'

Tagged questions
1
answer

Filter the return of Stored Procedure

I created the following SP: -- -------------------------------------------------------------------------------- -- Routine DDL -- Note: comments before and after the routine body will not be stored by the server -- ----------------------------...
asked by 27.11.2014 / 02:31
0
answers

Error procedure holiday

Good afternoon guys, I'm trying to create a procedure and I can not solve my error even after several searches on the net, if you can help me, the error that appears is this: can not format message 13: 393 - message file C: \ WINDOWS \ firebi...
asked by 01.12.2018 / 18:28
1
answer

How can I make a procedure to update the balance in postgres?

Mine has been giving a mistake that I can not understand talking about having a bug in $, but when I used another example procedure from the internet almost in the same way as mine did, then the error is being in how to do it procedure. The o...
asked by 22.11.2018 / 23:13
0
answers

How to use the result of a procedure in another procedure?

I have the following procedure: DELIMITER $$ CREATE PROCEDURE retornaArvoresFeedback() BEGIN SELECT id, flagFeedback, prazoFeedback FROM arvore_classificacao WHERE flagFeedback <> 'null' AND prazoFeedback <> '...
asked by 13.11.2018 / 13:10
1
answer

Return a Result set from a storedeProcedure MySql

Good afternoon. I have the following storedprocedure in MySql ..: DELIMITER $$ CREATE DEFINER='ricardo'@'%' PROCEDURE 'teste2'() BEGIN Select * from Tabela; END How do I call this storedprocedure by DELPHI 7 ? I'm using the ZEO...
asked by 22.09.2018 / 21:42
1
answer

MYSQL is terminating by itself when executing a procedure

I have a problem with my mysql on localhost. I use xampp as a service and HeidiSQL to facilitate the programming process. Finally, when executing the procedure below the MYSQL service is terminating alone and the error LOG returns the informatio...
asked by 09.09.2018 / 03:43
0
answers

Create Trigger to update table of BANK 2 when changing table of BANK 1

I have several databases BANK_1 (Main) BANK_2, _3, _4 ... (Companies). In every bank there is a company table, who have the same structure, in BANK_1 I have the company register of all BANK_2, _3, _4 ...! I would like to update any company infor...
asked by 07.09.2018 / 17:57
0
answers

Call PROC MVC to display the list of users who can not register

Attempting to call PROC sp_UsuariosVariasTentativasCadastro_Result , which brings up a list according to the form data. But nothing is happening. Can someone help me ?    NOTE: I created all these "layers" but I do not know if they have...
asked by 31.08.2018 / 19:45
0
answers

Problems with Stored Procedures in Laravel 5.6?

I am making a select in a procedure , but I can not page because the result returns array : DB::select('EXEC PR_MONITORAMENTO @FUNCAO="S2", @ID_CD_INTERNACAO='.$ID_INTERNACAO.', @ID_CD_CONVENIO='.$ID_CONVENIO.',@NM...
asked by 30.07.2018 / 16:27
0
answers

Value returned from procedure (PDO)

The procedure is running fine, but in case I am not able to get the value it returns, I already looked in the php documentation link , but not yet. function static function inserirCliente($cpf, $nome, $sobrenome, $usuario, $senha) { $...
asked by 06.07.2018 / 23:16