ORA-06550 DBMS_ALERT, PLS-00201

ORA-06550 ERROR, /5 PLS-00201: identifier 'SYS.DBMS_ALERT' must be declared


SYS USER로 로그인하여  USER와 PUBLIC에게  DBMS_ALERT 권한을 준다

1. Grant execute on DBMS_ALERT TO INS;

2. Grant execute on DBMS_ALERT to PUBLIC;