Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Novice: Loading Stored Procedure
How do you load a Stored Procedure into the Oracle environment? Currently, the
only way I go about doing this is copy/paste my PL/SQL code from a text file
into the SQLPLUS prompts. From my basic Oracle knowledge, I thought there was
a way for Oracle to load up an <file>.sql into it the environment. Then I
could run "EXECUTE <procedure name>" from a command line and/or UNIX script.
Thanks!
Gil
Received on Tue Apr 22 2003 - 12:02:54 CDT