Edit D:\app\Administrator\product\11.2.0\dbhome

Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\wf\demo\wfalerts.sql

/*=======================================================================+
 |  Copyright (c) 1999 Oracle Corporation Redwood Shores, California, USA|
 |                            All rights reserved.                       |
 +=======================================================================+
 | FILENAME
 |   wfalerts - Sample for implementing Alert type functionality using workflow
 | DESCRIPTION
 |   PL/SQL body for package:  WF_ALERT
 *=======================================================================*/

whenever sqlerror exit failure rollback;

create or replace package WF_ALERT as
/* $Header: wfalerts.sql 26.0 2000/07/05 23:15:23 kma ship $ */

procedure CheckAlert(itemtype   in varchar2,
               itemkey    in varchar2,
               actid      in number,
               funcmode   in varchar2,
               resultout  in out varchar2);

procedure ErrorReport ( document_id   in varchar2,
                    display_type  in varchar2,
                    document      in out varchar2,
                    document_type in out varchar2);
end WF_ALERT;
/

show errors package WF_ALERT
commit;
exit;

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de