Stack Overflow
Stack Overflow

Questions tagged [procedure]

A procedure is a subroutine that does not return a value. Do not use this tag for stored procedures. Use 'stored-procedures' tag instead.

A procedure is a subroutine that does not return a value.

Do not use this tag for stored procedures.
Use tag instead. If question is about stored procedures in Oracle then you can also use tag.

2740 questions
0
votes
1 answer

MySql Stored Procedure -> Variable or condition declaration after cursor or handler declaration

i try to create a stored procedure but get always a error when saving. I've tried the declaration in different orders but get the same error or the workbench closes without error. This procedure should save the datedif from different fields in…
K.G.
  • 1
0
votes
1 answer

Procedure Activation Time

Is procedure activation time a part of the compile time, whereby preparation for function calls is performed? Or is it a part of run time when the function is actually called? (Though unsure, I am hinging on the second option)
c user
  • 1
0
votes
2 answers

"Object '%' is not a sequence object" error

I'm trying to generate new number with these codes. CREATE SEQUENCE seq_fisnumarasi START WITH 1 INCREMENT BY 1 ; GO First of all, I 've created a sequence. CREATE PROCEDURE next_fis_number AS BEGIN SELECT NEXT VALUE FOR…
maliyassi
  • 79
  • 7
0
votes
1 answer

Using an address as a parameter in assembly

I'm writing a procedure with two parameters, one is a number and the other is an address to an array. How can I write the prototype for this? I was trying: Print proto dword: Asz, Addr Arrayn as well as: Print proto dword: Asz, OFFSET Arrayn but…
Google Z
  • 5
  • 3
0
votes
0 answers

Mysql select where procedure=1

I have procedure "CheckStatus" which returns 0 or 1. How I can use this query without HAVING? It's not work properly with limit 0,10 - it filtering rows with status=0 and I never got 10 results as I expected. Yes I understand that HAVING w/o GROUP…
rst630
  • 59
  • 2
  • 14
0
votes
1 answer

How to fetch new columns from a table in a procedure in mysql?

delimiter $$ create procedure getcstatus(vuser_name varchar(20)) begin select a.c_id, a.c_name, vga.* from a_c a inner join v_getalla vga on a.a_id=vga.a_id where a.c_name=vuser_name group by vga.a_id, vga.a_name, vga.c_name, vga.s_f_id,…
user3615152
  • 1
  • 1
0
votes
1 answer

Procedure Slow update records

How to improve the procedure to perform faster? I have 3 procedures, the first searches the balance before the second updates the balance and the third I use to do the processing where I call the two previous procedures. In short, when I insert a…
Renathu Cazari
  • 43
  • 8
0
votes
0 answers

Jboss automatically calls the PL procedures of the DB Oracle

What I pose is a problem I believe on the jboss side: in this case I have an asynchronous method (server side) that makes a normal call to a PL procedure on an Oracle DB. This procedure can take up to 12/15 minutes to finish. I noticed that after…
Marco R.
  • 1
  • 3
0
votes
1 answer

NOT FOUND Error handling for Update Procedure in My SQL

I am trying to write an sql stored procedure that will output an error message "ERROR! Campaign title does not exist" when there is no record corresponding to the input value (c_title). The procedure code is executing; however will not show the…
Luca Dimakopoulos
  • 1
0
votes
0 answers

x86 Program received signal SIGSEGV, Segmentation fault during debugging MASM32 assembly

I am tasked with writing my first assembly code which takes a number between 1-12 entered by the user and outputs the factorial. I need to write 3 procedures one for the input, one to calculate factorial and one to print the result. I believe I have…
Google Z
  • 5
  • 3
0
votes
0 answers

x86 No output from code and can't debug MASM32

include c:\asmio\asm32.inc includelib c:\asmio\asm32.lib includelib c:\asmio\User32.lib ; SASM files for I/O includelib c:\asmio\Kernel32.lib ; SASM files for I/O input proto ; 0 parameters Factorial proto nvx: dword ; 1…
Google Z
  • 5
  • 3
0
votes
0 answers

Passing a parameter through a function in Assembly MASM32

I am brand new to this language and my task is to create a program with 3 procedures. One procedure which asks the user for a number, another procedure which finds the factorial of that number, and a final procedure to print the information. I wrote…
Google Z
  • 5
  • 3
0
votes
1 answer

Trying to make a simple procedure in MASM32 (LNK1120)

; Library for I/O and other purposes include c:\asmio\asm32.inc includelib c:\asmio\asm32.lib includelib c:\asmio\User32.lib ; SASM files for I/O includelib c:\asmio\Kernel32.lib ; SASM files for I/O input proto ; 0 parameters ;…
Google Z
  • 5
  • 3
0
votes
0 answers

How to post data from a database on one sql instance to a database on a different sql instance Using SQLExpress2012

I have a production SQL instance and database using SQL Server 2012 Express. I need to archive (on demand) from this database to a different database on a different SQL Server 2012 instance (on a different machine). The archiving process requires…
user3049876
  • 23
  • 6
0
votes
0 answers

Inserting a PROCEDURE in query () in PHP

I've been trying to integrate a procedure together with PHP for a while, but when calling it, PHP still has errors: Overview: $database = null; function Conecta($server, $user, $port, $bd){ $GLOBALS['database'] = mysql_connect($server,…
pe.Math
  • 89
  • 1
  • 7
1 2 3
…
99 100