Hello all:
The following code works fine in Informix 14.10 dbaccess:
create table aat (id serial, b lvarchar(1024));
create procedure aap (v_b like aat.b) -- tried int, integer
insert into aat(b) values(v_b);
end procedure;
But when I try to execute it from Squirrel 4.1.0 (each statement
separately) it always gives me a syntax error for the parameter data
type of the 2nd statement:
Error: A syntax error has occurred. SQLState: 42000 ErrorCode: -201
Position: 30 Error occurred in: create procedure use0.aap(in v_id int)
returning lvarchar(1024)
The position changes but the error is always the same and it points at
the parameter declaration.
Do I have to change any settings in the driver/alias? I am using
jdbc-4.10.12.jar.
Thank you!
|