JDBC returns error - 674

Has anyone come across a -674 error when using JDBC to access a StoredProc in 9.4. Our client works OK with IDS7.31 FD3, but we get this error in 9.4 FC2. The error seems to be -- You might also see this error message if you write an expression that calls an SPL routine (stored procedure) that returns no values. For an SPL routine to be usable in an expression, the routine must return a value. If we change the SP to return a value the error goes away. We do not get the error if calling with Dbaccess or SQLEditor. Colin Bull c.bull@videonetworks.com sending to informix-list

I don't know about JDBC but in the webblade if the SPL is defined to return data there must a return clause in the code otherwise you a 674. The SPL is fine in dbaccess. The other nice one is if the code is defined to return an int and the code is something like call sp_test() returning int; sp_test select into int --single value return int with resume instead of sp_test select into int --single value return int; you can also get 674's Basically the webblade to SPL interface is very pedantic and not as forgiving as dbaccess. Colin Bull wrote: > > Has anyone come across a -674 error when using JDBC to access a StoredProc > in 9.4. > Our client works OK with IDS7.31 FD3, but we get this error in 9.4 FC2. > > The error seems to be -- > You might also see this error message if you write an expression that > calls an SPL routine (stored procedure) that returns no values. For > an SPL routine to be usable in an expression, the routine must return > a value. > > If we change the SP to return a value the error goes away. > > We do not get the error if calling with Dbaccess or SQLEditor. > > Colin Bull > c.bull@videonetworks.com > > sending to informix-list -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #