Re: error handling for SQR

[Ray Ontko <rayo@ONTKO.COM>]

Parika,

It is not possible to trap SQR errors.  At best, you could run the
from within another SQR and notice that SQR returned an non-successful
error status.

As for the CTRL-C, if the key is typed while a BEGIN-SQL or
BEGIN-SELECT block is executing, then Oracle will return a specific
status which you can check for in your ON-ERROR routine.

Hope this helps.

Ray
>         Is there any way to run an error handling procedure during an
> SQR error ? (not a SQL error)  I know there is an ON-ERROR option for
> BEGIN-SELECT statement and BEGIN-SQL statement.  However this will only
> handle SQL errors.  If an SQR error occurs, my error handling procedure
> will not get called.  By SQR error I mean any SQR execution errors :
> Graphics Box out of bound, user hits Ctl-C, array access errors, etc..
>         There is an EXECUTE statement, described in the user's manual,
> which looks like it would work.  However, it's only for SYBASE.  I am
> using Oracle, SQR 3.5 on Unix.
>
>         Any help will be greatly appreciated.  Thank You.
>

----------------------------------------------------------------------
Ray Ontko       |  Ray Ontko & Co  |  "Time for a new signature line."
rayo@ontko.com  |  Richmond, In    |  See us at http://www.ontko.com/