Icon View Incident Report

Serious Serious
Reported By: David Scheiner
Reported On: 1/11/2008
For: Version 1.07 Build 1
# 2521 Using EXCEPTION Block Without BEGIN..END Block Causes Error

The following SQL raises an error.

CREATE PROCEDURE "TestInsert" ()
BEGIN  
   DECLARE I INTEGER DEFAULT 1;

   REPEAT
      EXECUTE IMMEDIATE ''INSERT INTO GuidTable (Guid, Text)
                          VALUES (''''00e1c160-c03f-11dc-95ff-0800200c9a66'''',''''test1'''');'';

   EXCEPTION
      IF ERRORCODE()=1004 THEN
         EXECUTE IMMEDIATE ''Update GuidTable set Text = ''''test2''''
                            where Guid = ''''00e1c160-c03f-11dc-95ff-0800200c9a66'''';'';
      END IF;
   SET I = (I + 1);
   UNTIL (I > 2500) END REPEAT;

END



Resolution Resolution
Fixed Problem on 1/12/2008 in version 1.07 build 2


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image