1 SQL> @CTODB_EVENT_PKG_EL.sql 2 3 Package created. 4 5 No errors. 6 7 Warning: Package Body created with compilation errors. 8 9 No errors.
It`s very strange. See the code above. I put a show error behind the package header and package body. The script shows that package body compiled with error. But the show error didnt return any error message.
Any way, you can get those error message with the VIEW user_errors.
1 SQL> select * from user_errors where type='PACKAGE BODY' and name='CTODB_EVENT_PKG_EL'; 2 3 NAME TYPE SEQUENCE LINE POSITION TEXT ATTRIBUTE MESSAGE_NUMBER 4 -------------------- -------------------- ---------- ---------- ---------- ---------------------------------------- --------------------------- -------------- 5 CTODB_EVENT_PKG_EL PACKAGE BODY 1 609 25 PL/SQL: ORA-00942: table or view does no ERROR 0 6 t exist 7 8 CTODB_EVENT_PKG_EL PACKAGE BODY 2 609 13 PL/SQL: SQL Statement ignored ERROR 0 9 CTODB_EVENT_PKG_EL PACKAGE BODY 3 873 98 PL/SQL: ORA-00904: "CREATE_DT": invalid ERROR 0 10 identifier 11 12 CTODB_EVENT_PKG_EL PACKAGE BODY 4 873 13 PL/SQL: SQL Statement ignored ERROR 0 13 CTODB_EVENT_PKG_EL PACKAGE BODY 5 1305 25 PL/SQL: ORA-00942: table or view does no ERROR 0 14 t exist 15 16 CTODB_EVENT_PKG_EL PACKAGE BODY 6 1305 13 PL/SQL: SQL Statement ignored ERROR 0
But we just dont know why the show error command not working