Oracle Workflow Guide
Release 2.6.2

Part Number A95265-03
  Go to previous page Go to next page       Go To Table Of Contents Go To Index Go To Table Of Contents

                     Contents  Index  Glossary Master Index Feedback
 

GET_ERROR

Syntax

procedure GET_ERROR

 (err_name out varchar2,
err_message out varchar2
err_stack out varchar2);

Description

Returns the name of a current error message and the token substituted error message. Also clears the error stack. Returns null if there is no current error.

Example 1

/*Handle unexpected errors in your workflow code by raising WF_CORE exceptions. When calling any public Workflow API, include an exception handler to deal with unexpected errors.*/

declare
errname varchar2(30);
errmsg varchar2(2000);
errstack varchar2(32000);
begin
...
Wf_Engine.CompleteActivity(itemtype, itemkey, activity, result_code);
...
exception
when others then
wf_core.get_error(err_name, err_msg, err_stack);
if (err_name is not null) then
wf_core.clear;
-- Wf error occurred. Signal error as appropriate.
else
-- Not a wf error. Handle otherwise.
end if;
end;

See Also

CLEAR  
         Previous  Next          Contents  Index  Glossary


Oracle
Copyright © 1996, 2002 Oracle Corporation.

All Rights Reserved.