Re: Dbms problem.

Satish Narasimha wrote in message <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

If the user who is attempting to create this procedure is not 'sys' or has not had execute explicity granted on the dbms_alert package, then this error is expected.
The resolution therefore is to grant execute on dbms_alert to the user wishing to create this procedure.
NB It must be an explicit grant, i.e. a grant inherited through a role will NOT be accepted.

Ian. Received on Fri Nov 21 1997 - 00:00:00 CST