How to execute a procedure [message #394] |
Sat, 09 February 2002 08:54 |
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 |
Raj
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.
Raj
|
|
|