MySQL Forums
Forum List  »  Newbie

how can i get the error decription like SQLERRM in oracle within a stored procedure
Posted by: ralf dobrick
Date: February 01, 2005 09:36AM

hi,
within a stored procedure i want to write out an error description in a different logging-table.
in oracle there is a variable called SQLERRM that contains the error message.
via api there is a function mysql_error() that has the same content, but how do i have acces to that information within a stored procedure?

i tried different versions but it doesn't work.
insert into logbook (ts,error_text) values(sysdate(),mysql_error());
insert into logbook (ts,error_text) values(sysdate(),mysql_error);

can anybody help me?
thank you for any comment.

Options: ReplyQuote


Subject
Written By
Posted
how can i get the error decription like SQLERRM in oracle within a stored procedure
February 01, 2005 09:36AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.