|
From: Gerd W. <ger...@t-...> - 2021-06-03 00:39:01
|
Please go to menu File --> New Session Properties --> tab SQL --> Statement Separator. If the statement separator is ; change it to something else. Gerd Am 02.06.21 um 16:30 schrieb info: > 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! > > > > > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
