Re: dbms_alert package

In article <2k0mrl$efq_at_b30news.b30.ingr.com>, mlcampb1_at_ingr.com writes...
>
>What is the proper way to use the dbms_alert package supplied in V7. I
>am trying to use the example in the Application Developer's Guide on
>page A-19
>and it says to create a trigger on the emp table that looks like this:
>
>create trigger emptrig after insert or update or delete on emp
>begin
> dbms_alert.signal('emp_table_alert','message_text');
>end;
>
>But when I do this from within SQL*Plus I get the following errors:
>
>ORA-06550: line 3, column 1:
>PLS-00201: identifier 'DBMS_ALERT' must be declared
>ORA-06550: line 3, column 1:
>PL/SQL: Statement ignored
>
>What do I need to do to declare the dbms_alert package.
>

I wasted a lot of time on this little problem myself. As page 7-2 says run CATPROC.SQL from SQLPLUS as SYS. Received on Tue Feb 22 1994 - 18:49:02 CET