Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: executing a list of DDL statements in one call
Jerwynn wrote:
>
> thanks Mark,
>
> However, I need to read the script file from my own program, bypassing SQL plus,
> and send them to the server through an OCI function call. I found out that it
> the server could not accept the list of DDL statements in one call. There must
> something to wrap the list of DDL.
>
(1) write a sql-script containing all your sql-orders.
(2) if you want them to set as a logical unit (= operating on the same
data-snapshot) insert the correct set transcation - order at the begin
of the script and don't forget the commit-order at the end.
(3) save this script anywhere on your disk.
(4) call the svrmgr (on suns: call svrmgrl, not svrmgrm), that is: the
oracle sql-shell. you should get a lign with a sql-prompt like this
SQL>
(5) insert at the sql-prompt SQL> this: @$ANYWHERE\$MYSCRIPT
starting with an @ means: it follows the path of an scipt which shall be executed.
c'est tout
--
salut d'Allemagne kr