Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Dbms problem.
SYS should grant execute permission on dbms_alert to the user you are
creating this trigger.
Thanks,
Shajith
Satish Narasimha <satishn_at_blr.sni.de> wrote in article
<34757B19.4C11_at_blr.sni.de>...
> 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