Oracle9iAS Portal Developer Kit

get_text_stack function

Contained in package wwerr_api_error.

Call this function to return the current error stack, in l_message, in varchar2.

function get_text_stack

(

p_sep in varchar2 default OWA.NL_CHAR

)

return varchar2;

Version: Oracle9iAS Portal 9.0.2 or later

Parameters:

p_sep

The delimiter used between fields in an error stack record.

Note: A delimiter is a character, such as a comma or string, that is used to separate or to mark the start and end of column items of data in a database, or some other type of file or data container.

Datatype: in varchar2
Default: OWA.NL_CHAR

Returns:

This functions returns a list, in l_message, of the error messages currently in the error stack. The list includes: exception message, context, domain, and product or provider name.

Note: The exception context is presented as: [package].[function], as in wwnls.add_string.

Exceptions:

This function raises no user-defined exceptions.

Example:

wwerr_api_error.get_text_stack;

 

Related topics

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