Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: whenever sqlerror is an unknown statement?

Re: whenever sqlerror is an unknown statement?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 20 Jan 2006 19:31:00 +0100
Message-ID: <nva2t15h2fjpka2qhns763rmsaaeva1kqq@4ax.com>


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 DBA
Received on Fri Jan 20 2006 - 12:31:00 CST

Original text of this message

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