Icon View Incident Report

Minor Minor
Reported By: Harry de Boer
Reported On: 11/12/2007
For: Version 1.06 Build 1
# 2477 Line Numbers Incorrect for EXECUTE IMMEDIATE Compilation Errors in a Stored Procedure or Script

The following script results in the wrong line number and column number being reported for the EXECUTE IMMEDIATE statement.

SCRIPT
BEGIN
  DECLARE TempCursor CURSOR FOR stmt;

  PREPARE stmt FROM 'SELECT * FROM Information.Tables WHERE Name = ?';

  OPEN TempCursor USING 'TmpJTOV';

  IF (ROWCOUNT(TempCursor) > 0) THEN
     EXECUTE IMMEDIATE 'DROP TABLE tmpJTOV';
  END IF;

  CLOSE TempCursor;

  EXECUTE IMMEDIATE 'CREATE TEMPORARY TABLE tmpJTOV AS
                    SELECT extract(month from Datum) AS maand, SUM(Bedrag) AS bedr
                    FROM MyTable WITH DATA';

END



Resolution Resolution
Fixed Problem on 11/15/2007 in version 1.07 build 1


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