Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> EXCEPTION SPOOLING

EXCEPTION SPOOLING

From: <chandrasekar_at_my-dejanews.com>
Date: Thu, 11 Mar 1999 07:23:25 GMT
Message-ID: <7c7r18$c9a$1@nnrp1.dejanews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US