MySQL Forums
Forum List  »  Oracle

SQLERRM and SQLCODE
Posted by: Alex Cornet
Date: May 05, 2008 12:05PM

Hello,

Each stored proc that i develop using oracle pl/sql, in WHEN OTHERS clause i allways assign to an output parameter:

param_out = 'CODE:'|| TO_CHAR(SQLCODE)|| '#' ||
'MSG:' || SUBSTR(SQLERRM,1,200) || '#';

I don't know/find to do that in mysql storedproc, anybody can help me?
I know something about sqlstate and i know that it is possible to consult by mysql_sqlstate() using C++ API, but it is possible to put it into a param_out in a storedproc?.

thanks in advanced.

Alex Cornet,



Edited 3 time(s). Last edit at 05/07/2008 03:27AM by Alex Cornet.

Options: ReplyQuote


Subject
Views
Written By
Posted
SQLERRM and SQLCODE
8043
May 05, 2008 12:05PM


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.