Questions tagged as 'stored-procedures'

Tagged questions
2
answers

Pass table field as parameter in a procedure

I made this procedure to bring records of a table between dates, but I need to pass the date field of the table to the command between function, follow the code: DELIMITER // CREATE PROCEDURE pro_get_gastos(nome_tabela VARCHAR(20), data_ini DA...
asked by 18.06.2015 / 18:07
1
answer

Procedure with out parameter (SYSREFCURSOR) with Entity Framework

I have a problem that is making me sleepy. I am performing a database migration, from SQL Server to Oracle, in a C # application. The above application is using the Entity Framework to access the database. I have been able to migrate the data...
asked by 21.10.2014 / 20:35
0
answers

Call Query in php hangs other queries

Because when doing a first query to a call and then trying to make another one the php hangs? For example, running this simple stored procedure in php DELIMITER $$ CREATE DEFINER='root'@'localhost' PROCEDURE 'curtidas_sp' ( IN '@post' INT...
asked by 28.10.2018 / 02:20
1
answer

Versioning of Procedure

I'm having a bit of a conceptual doubt. I am currently working on a project where I will have to version the calls from some api's. For example: Urls: /api/V1.0/Chamados/1220 /api/V1.5/Chamados/1220 The difference between the two c...
asked by 17.07.2018 / 23:21
1
answer

Subquery returns more than one value

When performing an update within a procedure, the message appears saying that the comparison subquery brings more than one result. The subquery has been tested and only returns one result since it searches for the Exam id and this is unique for...
asked by 13.05.2018 / 16:37
0
answers

Conversion failed when converting the varchar value '@userID' to data type int

The error is what is in the title, conversion char to int. "Conversion failed when converting the varchar value '@userID' to data type int." Thanks for any help and if you have any tips on good practice, it's even better, because I'm new to this...
asked by 10.04.2018 / 20:48
1
answer

Why my procedure is not being accepted, I am using mysql6.3

create procedure cadastrar_nadador (out nome_v varchar(80),out sexo_v varchar(1),out nascimento_v date,out patrocinio_v varchar(80)) begin insert into nadador(nome,sexo,nascimento,patrocinio) values (nome_v,sexo_v,nascimento_v...
asked by 18.11.2017 / 21:53
0
answers

How to do a return from a Stored Procedure - MySQL

I'm doing a login screen, but I can not return the ID of the selected user. DELIMITER $$ USE webnote $$ CREATE PROCEDURE login (IN email2 varchar(60), senha2 varchar(16)) BEGIN if EXISTS(select id_aluno from aluno where email = em...
asked by 20.11.2017 / 20:13
0
answers

What is the meaning of Overhead in physical database design?

I just read about physical design and database tuning and I could not understand the concept of overhead, and therefore I could not understand what the author of the book wanted to explain. Previously I understand overhead as an overload or...
asked by 06.11.2017 / 20:49
0
answers

How to return a list by passing a DVT as a parameter

Good afternoon, guys. I am writing a query method and need to pass a list of charges to my procedure to get a list of employees. I'm trying to use a TVP instead of sending a string with concatenated Ids. However, I do not know how to add the par...
asked by 10.01.2017 / 18:32