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 -> Re: EXCEPTION SPOOLING

Re: EXCEPTION SPOOLING

From: Oracleguru, Suresh Bhat <oracleguru_at_mailcity.com>
Date: Thu, 11 Mar 1999 20:34:58 GMT
Message-ID: <01be6c0e$96cfdf20$a504fa80@mndnet>


Hi -

Why not spool it in SQL*Plus, rather than using PL/SQL.

In SQL*Plus, if you

        set doc off feedback off

you will not get any comments (/* ...... */) or the feedbacks such as "table created" etc.

Oracleguru
www.oracleguru.net
oracleguru_at_mailcity.com

chandrasekar_at_my-dejanews.com wrote in article <7c7r18$c9a$1_at_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 - 14:34:58 CST

Original text of this message

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