OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
[Stored Procedure] - Error handling

From: Ratheesh K J (ratheesh.csegmail.com)
Date: Tue Apr 15 2008 - 11:53:31 CDT

Hello folks,

Any way to retrieve the error code/error number from a stored proc.

Scenario
------------------

calling a stored proc from PHP - using mysqli_multi_query()
The stored proc has multiple queries. Lets say one of the queries generates
an exception.
How do I retrieve the error message within the procedure itself?

OR

Is there any way from PHP to get the last error msg? I tried with
mysqli_error().. Did not work..

Any inputs will be appriciated.

Thanks,
Ratheesh