Re: Extracting with sqlplus - what about errors?

[Quoted] 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 Thu Dec 12 2002 - 22:43:26 CET