Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: whenever sqlerror is an unknown statement?
On 20 Jan 2006 08:15:39 -0800, jjsavage_at_gmail.com wrote:
>Hi all,
> I downloaded Oracle XE (the free trial version), and I'm trying it
>out for my boss. I've got a script that contains the statement
>'whenvever sqlerror continue;' and the Run Script page says "You have
>requested to run a script containing statement(s) SQL Workshop will
>ignore. Please confirm your request." It says that "whenever sqlerror
>continue;" is an unknown statement. Is this an XE problem, or what?
>
>Thanks,
> John Savage
whenever sqlerror is a sql*plus statement, it is not a sql statement.
You need to find out whether SQL Workshop is meant to be a sqlplus
replacement. If it is not you need to find out how error trapping has
been catered for in SQL Workshop
-- Sybrand Bakker, Senior Oracle DBAReceived on Fri Jan 20 2006 - 12:31:00 CST