Questions tagged as 'stored-procedures'

Tagged questions
1
answer

Make a select according to an indexed table

I have a table, getSalas , which simplified something like this: CREATE TABLE getSalas( ID_SALA NUMBER(4), NOME_CARATERISTICA VARCHAR2(20), VALOR_CARATERISTICA NUMBER(4) ); The contents of this table are of the type:    1, '...
asked by 26.01.2017 / 14:04
1
answer

Problems in a query performed within a Stored Function in Mysql

I have a problem inside a query in Mysql performed within Funcion . The question is, among the various activities that the function is performing, is testing whether a given data has already been entered into a table. The tabl...
asked by 18.09.2016 / 19:38
0
answers

Show results of a Stored Procedure

I want to show the result of the procedure in a List I added in the model and generated this code. public virtual ObjectResult<string> SP_ListaDadosCarteiraPGC(Nullable<int> ano, Nullable<int> mes, string codex, string ada...
asked by 20.04.2016 / 20:41
2
answers

How to use store procedure with Doctrine

How do I use stored procedure with Doctrine? Should I use createNativeQuery?     
asked by 03.05.2016 / 15:36
0
answers

How to pass a parameter of type 'Nested Table' to a stored procedure in Oracle

I'm working with Oracle for just over 2 months and need to pass a dataset to be used in the query parameter inside the procedure. I searched a lot on the net and found no solution to solve my problem, I always get the same error message - incorr...
asked by 04.12.2015 / 15:30
1
answer

INSERT within clause WITH

I basically learned SQL with PostgreSQL, I am first making use of SQL Server and could not figure out how to do this in it. Let's say I have two tables. The first is a generic transaction table (sales, rentals, bookings, etc.) CREATETABLE[db...
asked by 05.07.2016 / 17:51
2
answers

Foreach in SQL to put a value in a variable

My problem is that I have a subquery that works perfectly, but for this I have to insert the id I want in the variables. In the @mediaKM_mes variable I select the tbl table by car id; in the @km variable I select the table tblCar by the car i...
asked by 11.07.2017 / 01:05
1
answer

Missing IF in procedure

I did the following procedure, but in END// 'missing if' appears, does anyone know why? William helped me with this problem, but whenever I try to register, the procedure only goes to the last else . I called it this wa...
asked by 06.07.2018 / 20:11
1
answer

I need explanations of OUT and PL / SQL INOUT and Mysql procedure

Well, I put PL / SQL and mysql because these two modes have procedures in both Oracle and mysql, but anyway. The IN mode I understood that it works like a constant, it is passed through the parameter and can not be changed inside the procedure ....
asked by 10.07.2018 / 21:07
1
answer

Problem in converting a query in vb.net to a procedure with varchar

Until the% of call of the parameters takes all data correctly, the problem is at the time of going to the procedure via ADO.net, that for example, I pass the values, function and in the procedure it picks up only the first character....
asked by 28.11.2017 / 11:57