Re: How to run a script in Pro* c or a Stored Pocedure?

From: Thomas Kyte <tkyte_at_oracle.com>
Date: 14 Mar 2002 16:03:14 -0800
Message-ID: <a6rdo2017lo@drn.newsguy.com>

In article <zbak8.13$Y85.1476_at_nsw.nnrp.telstra.net>, "zhao" says...
>
>Hi,
>
>Could anybody give me an ideal how to run a script in Pro*c or a stored
>procedure?
>
>Thanks
>
>Zhao
>
>

well, you would have to write a script parser that would find the statements and then execute them. You would basically have to write sqlplus in C or PLSQL. SQLPlus being a simple scripting environment after all that executes SQL.

Sort of like asking how to run "perl" in C, you would write a perl parser/interpreter.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Thu Mar 14 2002 - 18:03:14 CST