Re: Extracting with sqlplus - what about errors?

From: jparker <rjparker42_at_yahoo.com>
Date: 13 Dec 2002 05:57:11 -0800
Message-ID: <9c3d7f60.0212130557.24cb08d8_at_posting.google.com>


On the money. Much obliged.

cheers
j.

Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in message news:<an0ivugta5pj1e3aua8hroaoub1hhfo35r_at_4ax.com>...
> On 12 Dec 2002 10:39:58 -0800, rjparker42_at_yahoo.com (jparker) wrote:
>
> >Running an extract through sqlplus. Our client has an environment in
> >which disk tends to fill up. So checking what happens when sqlplus
> >cannot 'spool' to a file I find that I don't get an error, the process
> >just completes and goes on it's merry way. This is in spite of an
> >'whenever error' clause which one would think would trap an OS error
> >like that. Any thoughts?
> >
> >cheers
> >j.
>
>
> You'll need the
> whenever oserror
> for that
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Fri Dec 13 2002 - 14:57:11 CET

Original text of this message