How to load an external script file

Question

Let's say I've got a large script and want to cut it into pieces and then load the pieces from a main script file.

The question is how to load and execute an external script using plain SQL in Oracle DBMS or PL/SQL from another script file?

Roland Bouman · Accepted Answer · 2010-02-18 23:49:58Z

3

For SQL*plus, you can use:

@filename.sql

or

@@filename.sql

Please realize that @ is a SQL*plus command - not a SQL or PL/SQL command. SO you cannot use this from inside a PL/SQL stored procedure - it would not make much sense either, as essential context like current working direcory is absent in that case.

Form inside a stored procedure, you could in principle load external code using dynamic sql, but a better way to break up a stored procedure is to break it into several smaller stored procedures. If you like you can group those togehter in a package (see http://download.oracle.com/docs/cd/E11882_01/appdev.112/e10472/packages.htm#CIHIJECJ)

edited Feb 18, 2010 at 23:49

answered Feb 18, 2010 at 23:43

Roland Bouman

32.1k8 gold badges69 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Martin Kotula Over a year ago

The latter worked for me, thank you! I'm supposed to prepare a demo in which I create a schema, populate tables with data and create a package. All this is supposed to execute from a single file - that's the main reason I wanted to slice everything.

Collectives™ on Stack Overflow

How to load an external script file

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related