Ratheesh, There's a specific list for PHP database functions, "Databases and PHP" (PHP-DB), which you can find at http://php.net/mailinglists . I'm forwarding your message over to there, and recommend that you subscribe to that list. You'll probably get more direct responses by narrowing-down the lists to the support you need. LIST: Original message follows. On Tue, Apr 15, 2008 at 12:53 PM, Ratheesh K J <ratheesh.cse@xxxxxxxxx> wrote: > 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 > -- </Daniel P. Brown> Ask me about: Dedicated servers starting @ $59.99/mo., VPS starting @ $19.99/mo., and shared hosting starting @ $2.50/mo. Unmanaged, managed, and fully-managed! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php