Re: is sqlstate value availableinside the procedure ?
Yeah, but you'd have to enumerate all the sqlstates of you want that to work (wich is insane - if you could enumerate the set, you could probably handle it accordingly.). You really want to just have the internal sqlstate (or mysql errno or other equivalent) available.
But hey, maybe you can all add a comment to the existing bug report/feature request:
http://bugs.mysql.com/bug.php?id=11660
It was verified quite quickly, but that's all the response I got sofar.
The other way around (raising an error yourself) is just as impossible, althought there are some workarounds for that.
Subject
Views
Written By
Posted
1968
February 08, 2006 02:53PM
1264
February 08, 2006 05:18PM
1314
February 08, 2006 06:09PM
1326
February 09, 2006 09:02PM
Re: is sqlstate value availableinside the procedure ?
1337
February 11, 2006 12:52PM
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.