Posts

Showing posts with the label ora_sqlcode

Error Handling API

Originally heard about this from Patrick's blog months back. See  http://www.inside-oracle-apex.com/apex-4-1-error-handling-improvements-part-1/  and  http://www.inside-oracle-apex.com/apex-4-1-error-handling-improvements-part-2/ . Then a couple of weeks back I was looking at the new features on the Apex builder guide, where they mention about the enhanced error handling. See  http://docs.oracle.com/cd/E23903_01/doc/doc.41/e21674/what_new.htm#CEGIEDHE . So I thought I may as well set up a basic example to see how it is. The only sections in the documentation that really talk about it are: Application Definition Page Definition Which is basically about setting the error handling (PL/SQL) function. The main source of information is on the API docs for apex_error . This page talks about data types, and available functions/procedures you can use with this package, which will allow customising the displayed error message. Whilst the API docs do provide a goo...