I have a procedure in Informix and that procedure raise an exception at
first line, but that procedure don't return anything; only that
exception. The problem is that i can't take the exception message (
ifx_errormsg() don't return anything ). Other problem is that if i try
to make ifx_query("execute procedure proc_name") the res_id is FALSE !
Thanks.

Change the procedure so that it has a return value, for instance 0 = OK,
anything else is exception code.

Write an exception handler in the stored procedure that returns the
error code, and let the stored procedure return 0 when no exception is
raised.

This will let you execute an ifx_fetch_row() after the ifx_query() of
the stored procedure to retrieve the return code, and you can use the
returned column value in ifx_errormsg().

Danny
---

no feedback.