Re: problem with sqlplus and whenever error exit

From: <pjbondi_at_SystemDatabase.com>
Date: Mon, 20 Sep 1999 17:16:40 GMT
Message-ID: <7s5q5a$p7u$1@nnrp1.deja.com>

Hello to all:

SQL*PLUS seems to be so stupid that it will exit when there are errors in anonymous PL/SQL blocks, but not in stored procedures.

Can anyone confirm or deny this?

In article <7s5i9c$iu2$1_at_nnrp1.deja.com>, pjbondi_at_SystemDatabase.com wrote:
> Hello to all:
>
> I am using the following directives at the top of my script:
>
> spool &1\updatePortfolioEntry.out;
>
> set echo on;
> define LOGIN=&2
> set linesize 1000;
> set pagesize 1000;
> set flush on;
>
> whenever sqlerror exit 253;
>
> and my scripts have errors, but sqlplus does not exit. Any hints on
> what I might be doing wrong? Here is the output:
>
> Warning: Procedure created with compilation errors.
>
> SQL>
> SQL> show errors;
> Errors for PROCEDURE UPDATEPORTFOLIOENTRY:
>
> LINE/COL ERROR
> -------- -------------------------------------------------------------
--
> --
> 47/13 PL/SQL: SQL Statement ignored
> 54/32 PLS-00404: cursor 'CSR_PORTFOLIO_ENTRY' must be declared with
> FOR
> UPDATE to use with CURRENT OF
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Sep 20 1999 - 12:16:40 CDT