Re: Informix stored procedure

Posted in 2005

Adam Tauno Williams — Mon, 28 Nov 2005 10:49:38 -0500 — source: Usenet: comp.databases.informix

> I need to create a stored procedure, but keep getting a syntax error. > Error message : > Error: A syntax error has occurred. (State:37000, Native Code: FFFFFF37) > The code is : > create procedure test() I think you need a semicolon. > DECLARE lv_tk CHAR(15), > ln_tk_count INT These are either two seperate variables or a ROW type. [demime 1.01d removed an attachment of type application/pgp-signature which had a name of signature.asc] sending to informix-list