Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> SQLDBA sessions
Greetings, Fellow OraHax!!
I am currently running v7.x on AIX, SunOS and HP-UX, with other
Unii to follow at some point in time. I am writing a horrendously
complicated script which generates another horrendously complicated
script to be fed through SQLDBA. The SQLDBA script is of the
format:
do_sql_action;
exit
So far, to the best of my analysis, the SQL script waits for the
subprocess to complete before issuing the next statement (SQL or
Unix). And, this is fine by me, 'cuz I need synchronous processing
on this one. Has anyone, on ANY UNIX platform, seen the subprocess
submitted asynchronously (or spawn/nowait for you VMSheads) ??
This, of course, begs the secondary question: if I *needed*
asynchronous processing, is there anyway to tell SQLDBA to do
that ??
Extra credit awarded to anyone answering both questions...
Bambi.
Received on Fri Jan 19 1996 - 16:24:42 CST
!do_unix_action
do_some_more_sql_stuff;
!do_some_more_unix_stuff
more_sql;
more_sql;
still_more_sql;
!more_unix_junk
!and so on ad nauseum
![]() |
![]() |