Previous	Next		Contents	Index	Glossary

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