Hi, when I try to declare local variables with the VARCHAR data type (see example below) I get a -5015 error (Syntax error or access violation;-5015 POS(164) Missing keyword:REAL,FLOAT,FIXED,CHARACTER,CHAR,TI) although the reference manual says that VARCHAR is an allowed data type for a local variable.
CREATE DBPROC TEST_PROC (IN P_1 VARCHAR(30) ,IN P_2 VARCHAR(50) ,OUT P_3 BOOLEAN ,OUT P_4 INTEGER) AS VAR V_1 BOOLEAN; V_2 INTEGER; V_3 VARCHAR(30); V_4 VARCHAR(50); BEGIN SET V_1 = FALSE; END; If I change the data types of v_3 and v_4 to CHAR (V_3 CHAR(30); V_4 CHAR(30);) then the stored procedure seems to be o.k. Is there something wrong with the DDL-statement? Thanks in advance! Frank Schimmelpfennig PHILIPS Semiconductors Hamburg ATO-PICTOH IT&DataSupport Tel.: +49 40 5613 -1835, Fax: -3020