| get_errors function

Related topics
Contained in package wwerr_api_error. Call this function to return the error stack records in a table. Error handling routines can use this information to take specific corrective action or to provide their own UI. function get_errors return error_table;

Version: Oracle Portal 3.0.6.6.5 or later
Returns: This function returns a list of the entries in the error stack. Exceptions: This function raises no user-defined exceptions. Example: declare l_error_table wwerr_api_error.error_table; begin wwerr_api_error.add ( p_domain => wwerr_api_error.DOMAIN_WWC, p_sub_domain => 'err', p_name => 'oracle_generic', p_context => 'example.test', p1 => 'test_error' ); l_error_table := wwerr_api_error.get_errors; end; Example error stack record: wwc, 36000, test_error-, example.test, wwc, err, oracle_generic In this example: wwc is the domain name (product) 36000 is the NLS error message ID (code) test_error- is the text of the error (text) example.test is the context of the error, or the name of the package where the error occurred (context) wwc is the error’s NLS string domain name (msg_domain) err is the error’s NLS string sub-domain name (msg_sub_domain) oracle_generic is the error’s NLS string name (msg_name)

Related topics
Error API package | PDK PL/SQL API Reference - Home

Back to top
The PL/SQL API Reference is part of the Portal Developer Kit on Portal Studio