Re: [Stored Procedure] - Error handling

[email protected] ("Daniel Brown")
Newsgroups php.db
Message-ID <[email protected]>
    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 <[email protected]> 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!
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.