Re: Dbms problem.

look at the explanation about mutating tables on my web page.

joe

Satish Narasimha wrote:

> Hello,
> Can anybody tell how to solve this error?
>
> SQL> create trigger emptrig after insert or update or delete on emp
> 2 begin
> 3 dbms_alert.signal('emp_table_alert', 'message_text');
> 4 end;
> 5 /
> create trigger emptrig after insert or update or delete on emp
> *
> ERROR at line 1:
> ORA-06550: line 3, column 1:
> PLS-00201: identifier 'SYS.DBMS_ALERT' must be declared
> ORA-06550: line 3, column 1:
> PL/SQL: Statement ignored
>
> Thanks in advance.
>
> from
> satish:satishn_at_blr.sni.de

--
Joseph S. Testa, Oracle Database Administrator, mailto:jtesta_at_scioto.net
(home)
Vice-President Ohio Oracle Users Group,
See the Oracle FAQ at http://www.orafaq.org
Try http://web.scioto.net/jtesta that is also the place to find the
FREE, drop column script
ICQ UIN:  2832230(&oracle, home).