Re: Trapping Return Codes within a Stored Procedure.

On Mon, 29 Jun 1998, Viegas, John wrote: > We are using informix 7.21 on aix 4.1.5. > Within a stored procedure, it seems we are unable to use the "sqlca" > structure to get the sqlcode. Is this function inaccessible within > stored procedures? Yes, it is inaccessible -- SQLCA is a front-end artefact. > If so, is there any other way to trap return codes? Yes. RTFM: ON EXCEPTION in the Informix Guide to SQL: Syntax, in the section on SPL. Also, DBINFO(), same manual, different section for other parts of the SQLCA structure. Yours, Jonathan Leffler (jleffler@informix.com) #include <witticism.h> Guardian of DBD::Informix -- see http://www.perl.com/CPAN