Re: SPL, how to check for errors after executing Inserts, updates, etc..

Posted in 1999

Jonathan Leffler — Wed, 10 Feb 1999 15:53:13 -0800 (PST) — source: Informix-list mailing list archive (1991-1998)

On Wed, 10 Feb 1999, Stanislav Paltis wrote: > I am writing Stored procedure for informix 7 server. I execute Insert > statement inside SP and can't really check SQLCODE, or any other > variable if row was inserted correctly. > > Their examples don't give you anything about error checking after > execution of SQL statements in SP. ON EXCEPTION? As documented in the SPL section of the Informix Guide to SQL: Reference? Yours, Jonathan Leffler (jleffler@informix.com) #include <wish/I/was/skiing.h> Guardian of DBD::Informix v0.60 (v0.61_02) -- http://www.perl.com/CPAN Informix IDN for D4GL & Linux -- http://www.informix.com/idn