Toad World® Forums

parser errors in editor - latest drop


#1

Message from: john.enevoldson_671

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.


Historical Messages

Author: john.enevoldson_671
Date: Fri Sep 03 02:38:26 PDT 2010
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.
__



#2

Hi John,

I am not receiving any errors when attempting your same test.
Can you send me the error you receive and any supporting documentatino
that’s available?
Thanks

Nancy Alsip


#3

Message from: john.enevoldson_671

Hi Nancy, We get no errors its just that after building the stored procedure and
then refreshing the explorer view and then send the stored procedure to a new
editor the new editor window is not showing the complete stored procedure. All
we see is: CREATE OR REPLACE PROCEDURE “PXX”.“CHARTEST” ( IN “IN1”
CHARACTER(18), OUT “UT1” CHARACTER(5) ) SPECIFIC “CHARTEST” LANGUAGE SQL NOT
DETERMINISTIC EXTERNAL ACTION MODIFIES SQL DATA OLD SAVEPOINT LEVEL 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.;
Regards, John


Historical Messages

Author: john.enevoldson_671
Date: Fri Sep 03 08:32:23 PDT 2010
Hi Nancy, We get no errors its just that after building the stored procedure and
then refreshing the explorer view and then send the stored procedure to a new
editor the new editor window is not showing the complete stored procedure. All
we see is: CREATE OR REPLACE PROCEDURE “PXX”.“CHARTEST” ( IN “IN1”
CHARACTER(18), OUT “UT1” CHARACTER(5) ) SPECIFIC “CHARTEST” LANGUAGE SQL NOT
DETERMINISTIC EXTERNAL ACTION MODIFIES SQL DATA OLD SAVEPOINT LEVEL 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.;
Regards, John
__

Author: Nancy Alsip
Date: Fri Sep 03 07:26:06 PDT 2010
Hi John, I am not receiving any errors when attempting your same test. Can you
send me the error you receive and any supporting documentatino that’s
available? Thanks Nancy Alsip
__

Author: john.enevoldson_671
Date: Fri Sep 03 02:38:26 PDT 2010
Message from: john.enevoldson_671 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. _______________________________________
Historical Messages Author: john.enevoldson_671 Date: Fri Sep 03 02:38:26 PDT
2010 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. __


__



#4

Thanks John. I see the same results.

I have created CR 77,997 to track this issue.
Nancy


#5

Hi Nancy,
We get no errors its just that after building the stored procedure and then refreshing the explorer view and then send the stored procedure to a new editor the new editor window is not showing the complete stored procedure. All we see is:

CREATE OR REPLACE PROCEDURE “PXX”.“CHARTEST” (
IN “IN1” CHARACTER(18),
OUT “UT1” CHARACTER(5) )
SPECIFIC “CHARTEST”
LANGUAGE SQL
NOT DETERMINISTIC
EXTERNAL ACTION
MODIFIES SQL DATA
OLD SAVEPOINT LEVEL
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.;

Regards,

John