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