PHP 4.0 Bug #7129 Updated: I can't take the exception message for a procedure.

ID: 7129 Updated by: danny Reported By: acornel@nivis.ro Status: Assigned Bug Type: Informix related Assigned To: danny Comments: 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 --- Previous Comments: --------------------------------------------------------------------------- [2000-10-11 03:01:11] acornel@nivis.ro 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. --------------------------------------------------------------------------- Full Bug description available at: http://bugs.php.net/?id=7129