Re: Dbms problem.

Hi,
Connect as DBA.
grant execute on sys.dbms_alert to trigger_owner. Trriger_owner must have execute privilege on sys.dbms_alert directly, not via role.

                        Peter.

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
Received on Fri Nov 21 1997 - 00:00:00 CST