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 #