Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Simple Q re calling script from within another script

Simple Q re calling script from within another script

From: Holger Peine <peine_at_iese.fraunhofer.de.omit-this-junk>
Date: Fri, 10 Oct 2003 08:53:54 +0200
Message-ID: <3f8657a5@news.fhg.de>


Hello everyone,

this question seems ridiculously simple, but I honestly searched the SQL and PL/SQL reference manuals to no avail:

I have a script init.sql containing statements initializing my database (e.g. creating roles, users, tables etc.), and another script initspecial.sql containing some more initializations which I'd like to keep in a separate file (e.g. inispecial might be a file defining a package). Now I'd like init.sql somehow call (load/source/exec - whatever you'd like to call it) initspecial.sql (i.e. exactly what is done in sqlplus by the start command). How do I do this in PL/SQL??

Thanks for your help,
Holger Peine

-- 
Dr. Holger Peine
Fraunhofer IESE, Kaiserslautern, Germany
Phone +49-6301-707-134, Fax -209 (shared)
www.iese.fraunhofer.de/Staff/peine -- PGP key on request or via pgp.mit.edu
Received on Fri Oct 10 2003 - 01:53:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US