Designer 2.1.2: Exception in stored procedures.

From: Michael Efis <michael_at_cbr.spb.ru>
Date: Tue, 27 Apr 1999 10:39:20 +0400
Message-ID: <37255B98.327109DD_at_cbr.spb.ru>

Designer 2.1.2: Exception in stored procedures.

[Quoted] I have migrated from Designer 2.1 to 2.1.2 and faced the following problem:

For example: I have 'test' procedure
tst Except and tst Except2 are exception and they defined in the 'test' procedure
This is code of the 'test' procedure:

BEGIN
     RAISE tstExcept;
EXCEPTION

     WHEN tst Except THEN
           NULL;
     WHEN tst Except2 THEN
           NULL;
     WHEN OTHERS THEN
          NULL;

 END; Designer generates it into:

CREATE OR REPLACE PROCEDURE TST
 IS
-- Program Data

TSTEXCEPT2 EXCEPTION;
TSTEXCEPT EXCEPTION;

• PL/SQL Block BEGIN RAISE tstExcept; EXCEPTION WHEN TSTEXCEPT2 THEN -- !!!! WHEN TSTEXCEPT THEN -- !!!!

     WHEN tst Except THEN
           NULL;
     WHEN tst Except2 THEN
           NULL;
     WHEN OTHERS THEN
          NULL;

 END; Is there a way to resolve it ?

Michael. Received on Tue Apr 27 1999 - 08:39:20 CEST