Most voted "procedure" questions
A Procedure is a subroutine that does not return a value. DO NOT use this tag for stored procedures,use the tag [stored-procedures].
Learn more…115 questions
Sort by count of
-
0
votes0
answers72
viewsI can’t run Precedent in PHP - Fatal Error on the execute line( )
I cannot run a precedent by PHP, at the time of sending the PDO execute displays the image error, in my base oracle the Procedure runs normally. I tried to make it display the SQL error but failed…
-
0
votes0
answers46
viewsProblem to create Database with Mysql variable
I have a problem to create a database in Mysql. The term is as follows:. CREATE PROCEDURE trata_busca() BEGIN DECLARE excessao INT default 0; <--- LINHA QUE ESTA APONTANDO PROBLEMA DECLARE…
-
0
votes2
answers82
viewsInfinite loop in Precedure
I have a table Categoria with CategoriaId of Primary key and CategoriaPaiId Foreign key with self relationship in CategoriaId. I need to create a procedure listing the category tree. Assuming I have…
-
0
votes2
answers160
viewsStored Procedures in Mysql runs but cannot access to view or edit
When I had an account on a shared server at Hostgator(those very basic plans) I created some Stored Procedures in Mysql via my Navicat, months later I had to format my machine and migrated my plan…
-
0
votes1
answer107
viewsHow to run an oracle database via c# with no data return?
I am developing a WEBAPI in c# that runs a precedent on Oracle and after this procedure, it queries a table. This precedent only deletes data from a time table and inserts the the data informed in…
-
0
votes1
answer30
viewsHow do I get back the id of the new record created in a table using cursor and Procedure in SQL Server?
I’m trying to make my previous run and return the registration ID that has just been created, as I don’t have much knowledge of cursors and procedures I don’t know where I am failing. When I run the…
-
0
votes1
answer20
viewsImplementing view
Display statement of a particular account with the respective movements of a 15 days prior to the request date with the following data: Agency; Account number; Name of the account holder; Account…
-
0
votes0
answers21
viewsUsing "json_populate_recordset" in Postgre in fields other than json x table input
I have a proc where you have to input the JSON file and insert it into a temp table(_test). resultTeste := (select dados ->'Documento'->'Apolice' from _teste as result); INSERT INTO…
-
0
votes0
answers25
viewsArray return in C#
When I assign a function that returns an array to another array, I do not have the corresponding values of each index as assigned within the function. I need to return three percentages that are…
-
-1
votes1
answer493
viewsPLSQL - Procedure for Password Encryption
I searched on the internet a precedent for encrypt the users password, however I only found functions. There is how to generate a Procedure to carry out this process? CREATE OR REPLACE FUNCTION…
-
-1
votes1
answer1899
viewsCall Procedure inside another
I need to create a precedent enviar_email_servidores call in another pr_envia_email. The term to be called (pr_envia_email) has the function of sending email, and I need the message sent to this…
-
-1
votes1
answer1299
viewsProcedure in Mysql to clone products, Using CURSOR FOR SELECT
I need to clone the data from an EST_PROD_PRECO_CUSTO_EMPRESA table of id x company for the same table but of the company with id y. in Pl/Sql I did so. DECLARE CURSOR v_precos IS SELECT ID_PRODUTO,…
-
-1
votes1
answer53
viewsInsert values x into table A if exist on table B
I want to Insert in table A of the key field, but only if this key already exists in table B Example Insert key(123) in table B if there is key(123) in table a (am using sql procedures managemente…
-
-1
votes1
answer68
viewsHow to insert the average of a table into another table?
I created this bank: create table aluno( codaluno int primary key, nome varchar(30), datanasc date); create table curso( codcurso int primary key, descricao_c varchar(200)); create table disciplina(…
-
-3
votes1
answer21
viewsSql server heritage in Procedure
I’m having performance problems using views mapped in the EPH to use linq for grouping and paging. It would have a way to assemble a procedure basis, where I explained what it would take for all the…