error while creating type in oracle
Below error is cmoing while cresting type in oracle 11.2.0.3
SQL> @create_fin.sql
Type created.
Type body dropped.
Warning: Type Body created with compilation errors.
SQL> sho err
Errors for TYPE BODY XXIPPMCK.XXMCK_JOB_OT:
LINE/COL ERROR
-------- -----------------------------------------------------------------
87/9 PL/SQL: Statement ignored
87/9 PLS-00201: identifier 'DBMS_ALERT' must be declared
88/9 PL/SQL: Statement ignored
88/9 PLS-00201: identifier 'DBMS_ALERT' must be declared
123/13 PL/SQL: Statement ignored
123/13 PLS-00201: identifier 'DBMS_ALERT' must be declared
157/19 PL/SQL: Item ignored
157/42 PLS-00201: identifier 'DBMS_ALERT' must be declared
169/9 PL/SQL: Statement ignored
173/11 PLS-00320: the declaration of the type of this expression is
incomplete or malformed
1