problem with sqlplus and whenever error exit

From: <pjbondi_at_SystemDatabase.com>
Date: Mon, 20 Sep 1999 15:02:13 GMT
Message-ID: <7s5i9c$iu2$1@nnrp1.deja.com>

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. Received on Mon Sep 20 1999 - 10:02:13 CDT