Toad World® Forums

parser errors in editor - latest drop


#1

Hi,
The latest drop has solved some of the issues we had with parser errors in the earlier beta, but there are still problems.
The following illustrates the new issue:

CREATE PROCEDURE “PXX”.“CHARTEST”
(IN “IN1” CHARACTER(18),
OUT “UT1” CHARACTER(5)
)
SPECIFIC “PXX”.“CHARTEST”
LANGUAGE SQL
NOT DETERMINISTIC
CALLED ON NULL INPUT
EXTERNAL ACTION
OLD SAVEPOINT LEVEL
MODIFIES SQL DATA
INHERIT SPECIAL REGISTERS
P1: BEGIN
– Declare variables
DECLARE SQLSTATE CHAR(5) ;
DECLARE ENDTABLE INT ;
DECLARE hSqlState CHAR(5) ;

-- Declare handler
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION, SQLWARNING, NOT FOUND
begin
   get diagnostics exception 1
	          CHARTEST.UT1 = message_text;

	 SET hSqlState = SQLSTATE;
   set CHARTEST.UT1 = '';
  end;

set ut1 = 'X';

END P1;

Build this and then try to open in a new editor window.

Not good !

Regards,

John.