Re: Importing PL/SQL code into database

From: Jeffrey Rubin <jhrubin_at_saviar.com> >> I have some PL/SQL code on my hard drive that I would like to import into my  database <<

Yes, you can use sqlplus to store the pl/sql into the database providing the  code is a function, procedure, or package. Un-named pl/sql blocks can be  executed from sqlplus, but not stored into the database (at lease not as  executable module).

1. The pl/sql should be stored in a file with a .sql extention.
2. Logon to sqlplus as the schema owner or as a dba
3. type start file_name or @file_name to execute the code in the file

Once stored in the database procedures are executed from sqlplys using the  'execute procedure_name' command. You may have a parameter list.

Hope this helps.
Mark Powell -- The only advise that counts is the advise that you follow so follow your own advise Received on Mon Oct 13 1997 - 00:00:00 CDT