Questions tagged as 'stored-procedures'

Tagged questions
1
answer

Variable returning null value

I am creating a procedure for storing the food name in the food variable of the procedure, follow the code: DELIMITER $$ CREATE PROCEDURE armazena_nome(id INT, OUT alimento VARCHAR(20)) BEGIN SELECT alimentos_dados.nome_alimento INTO alime...
asked by 17.12.2017 / 20:10
0
answers

How to execute a SQL statement concatenated with a variable in a Procedure in MySQL

I'm creating a procedure to create a base and some tables within that base. I get the name of the base to be created by parameter. I'm having trouble concatenating this parameter next to the table creation script. Below is the code I did:...
asked by 29.12.2017 / 14:29
0
answers

Display image in Excel using binary code

I have a report on Excel where data is displayed through stored procedure . I have a problem because when I look for the value of the image field that is blob , it displays the binary code in the report instead of the image...
asked by 09.01.2017 / 02:56
1
answer

PHP SQLServer Stored Procedure Does Not Run Correctly

Hello, I'm developing an application using Laravel Framework Handler from my Backend and found the following error. My SqlServer Express 2008 R2 database has a stored procedure that performs a series of routines and inserts data already forma...
asked by 19.12.2016 / 16:34
2
answers

Passing value of a VARCHAR variable in the WHERE IN command

Good evening. I have the following example procedure CREATE PROCEDURE sp_listaFuncionarios @nome_dept varchar(50) as SELECT * FROM Funcionarios WHERE nome_departamento IN (@nome_dept) If, during the procedure call, you want to pass two c...
asked by 14.01.2016 / 01:30
4
answers

How to write a store procedure that uses values from the current and previous row?

I have the following table, # id # dataTmp # referencia #nProduz#nStock # id2 #necessi# # 115237 # 31-01-2017 # VL03280103 # 0 # 0 # 6 # 0 # # 115238 # 01-02-2017 # VL03280103 #...
asked by 30.01.2017 / 15:26
2
answers

Call Stored Procedure with JPA 2.0

I need to call the following procedure below, so the company projects use JPA 2.0 and all the examples I encounter are for JPA 2.1 + . prc_performance_vendas_obter(vdataini => :vdataini, vdatafim => :vdatafi...
asked by 06.03.2017 / 21:27
2
answers

Tool to debug a stored procedure in linux

I would like to know if anyone knows or even ever used any tool to perform a debug in stored procedures in linux . > I am currently using the MySQL Workbench and the DBvisualizer , but as far as I know none of them provide procedure...
asked by 27.02.2015 / 20:42
1
answer

How to stop stored procedures in MySQL?

Is it possible to stop a stored procedures in MySQL ? I put a procedures to feed a database table for load tests with 10 million records, however the insertion is very slow and I wanted to stop it without having to stop the...
asked by 26.02.2016 / 14:47
2
answers

Strange behavior in EntityFramework with StoredProcedure?

I'm performing a search through StoredProcedures in EntityFramework and the Data field is displaying conversion error to type String . Method public IEnumerable GetFilteredList(ConsultaBanner filtro) { st...
asked by 01.06.2017 / 14:51