| 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