Re: 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.

In SQLPLUS, type

  _at_<file>.sql

in order to load (execute) the contents of <file>.sql

hth
Rene Nyffenegger

-- 
  Projektleitung und Entwicklung in Oracle/C++/C# Projekten
  http://www.adp-gmbh.ch/cv.html