Oracle Workflow Guide
Release 2.6.2

Part Number A95265-02
Previous Next       Contents Index Glossary
         Previous  Next          Contents  Index  Glossary

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 © 2002 Oracle Corporation.

All Rights Reserved.