trying to use sqlplus to do a build and making it dynamic

From: Rick Ricky <ricks12345_at_gmail.com>
Date: Wed, 4 Jun 2008 13:05:51 -0400
Message-ID: <81f4c0700806041005xeb1fcdft962f8528080438f4@mail.gmail.com>


I can do this with a shell or with any other programming language and call sqlplus. I am trying to do this with just sqlplus scripts. I have code to do a build where I create tables, users, etc... Some of these can have some differences between databases (such as tablespaces) and some other things. I would prefer not to have to do:

prompt please enter tablespace name
accept tablespace
@mytablescripts &tablespace

I would like to use some form of configuration table. Is there anyway to do the following.

have a configuration table with data in it query it in a script and put it in a variable. (this is easily done with pl/sql)
then pass that variable to a new script.

I would need to query the data and put it in some form of sqlplus variable that I can pass to another sqlplus script.

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 04 2008 - 12:05:51 CDT

Original text of this message