| execution of pl/sql procedure [message #7769] |
Mon, 07 July 2003 12:15  |
pani
Messages: 1
Registered: July 2003
|
Junior Member |
|
|
HI
I AM LOOKING FOR HOW TO EXECUTE THE PARTICULAR PL/SQL FILE.LIKE
EXAMPLE MY FILE NAME IS MYFILE.SQL.
HOW TO EXECUTE THE MYFILE.SQL
Best regards.
PANI
|
|
|
|
| Re: execution of pl/sql procedure [message #7772 is a reply to message #7769] |
Mon, 07 July 2003 15:17  |
 |
Barbara Boehmer
Messages: 9090
Registered: November 2002
Location: California, USA
|
Senior Member |
|
|
To execute a .sql file, that contains PL/SQL and/or SQL and/or SQL*Plus commands, or commands to create a stored procedure, from the SQL> prompt in SQL*Plus:
START myfile.sql
or:
@ myfile.sql
To execute a stored procedure that has already been created by starting a file in the manner indicated above, from the SQL> prompt in SQL*Plus, or within a .sql file:
EXECUTE procedure_name (parameters)
You can also execute a stored procedure from an anonymous pl/sql block within a .sql file, or a pl/sql block within another procedure:
BEGIN
procedure_name (parameters);
END;
/
In the above examples, the .sql is optional, the space after @ is optional, and you may abbreivate EXECUTE as EXEC.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
