Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> EXCEPTION SPOOLING
Hi all,
I've a reasonable requirement for which I am unable to find a solution .
Here my problem goes :
"I've a create script which creates 75 tables (ALL CREATE STATEMENTS ARE GIVEN ONE AFTER OTHER ). Once if I run the script,it should write the errors(if any) in a file. I don't want to spool the entire operation . I want to spool only the error message(if any) . Is there a way to do this using PL*SQL procedures which in turn calls the script and writes the error messages ."
ALL YOUR INNOVATIVE IDEAS ARE WELCOME
Thankx in advance
chandrasekar
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Mar 11 1999 - 01:23:25 CST
![]() |
![]() |