Home » SQL & PL/SQL » SQL & PL/SQL » How to execute a procedure
How to execute a procedure [message #394] Sat, 09 February 2002 08:54 Go to next message
Nathalie Harbonne
Messages: 8
Registered: February 2002
Junior Member
How to execute a procedure

Can you tell me how to execute a procedure?

Once i have done the code, i want to execute a procedure(named for example proc13)but i don't succeed to.

If i do @proc13.sql i receive the message : it is impossible to open the sql file (with an extenstion .sql).

Can you explain me exactly how to execute a procedure please.

I have created a lot of procedure but i don't success to execute them, so it is very unpleasant.

Secondly, is it possible to take the code of a procedure and to put it in a simple pl/sql treatment.

Thirstly, when do we have to compile before executing, and how do we do to compile.

thanks a lot for all

Nathalie Harbonne
Re: How to execute a procedure [message #421 is a reply to message #394] Mon, 11 February 2002 08:06 Go to previous message
Messages: 411
Registered: November 1998
Senior Member
create the procedure ,
then type 'exec proc13;' at the sql prompt.
this will execute the procedure.
Second and third qns not clear.
Previous Topic: output parameters in stored procedure
Next Topic: help
Goto Forum:

Current Time: Sun Sep 19 12:47:17 CDT 2021