Message-ID: <3f8657a5@news.fhg.de>
From: Holger Peine <peine@iese.fraunhofer.de.omit-this-junk>
Subject: Simple Q re calling script from within another script
Newsgroups: comp.databases.oracle.misc
Date: Fri, 10 Oct 2003 08:53:54 +0200
Lines: 22
Organization: Fraunhofer IESE, Kaiserslautern, Germany
User-Agent: KNode/0.7.1
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7Bit
Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!in.100proofnews.com!in.100proofnews.com!npeer.de.kpn-eurorings.net!usenet-feed.fhg.de!news.fhg.de!not-for-mail
Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:132178

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