Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> dbms_defer package invalid in Oracle 8.1.7
I downloaded Oracle 8.1.7 for Solaris from http://technet.oracle.com.
Installed it, migrated a test database.
dbms_defer was invalid after the upgrade.
Ran dbmsdefr.sql, which contains the dbms_defer package.
The package definition contains procedures, like time_arg, which have definitions in the package header, but not in the package body.
Here are the results from show errors after trying to recompile the package body:
LINE/COL ERROR
-------- ----------------------------------------------------------------- 422/13 PLS-00323: subprogram or cursor 'TIME_ARG' is declared in a package specification and must be defined in the package body 432/13 PLS-00323: subprogram or cursor 'TIMESTAMP_ARG' is declared in a package specification and must be defined in the package body 442/13 PLS-00323: subprogram or cursor 'TTZ_ARG' is declared in a package specification and must be defined in the package body 452/13 PLS-00323: subprogram or cursor 'TSTZ_ARG' is declared in a package specification and must be defined in the package body 462/13 PLS-00323: subprogram or cursor 'IYM_ARG' is declared in a package specification and must be defined in the package body 472/13 PLS-00323: subprogram or cursor 'IDS_ARG' is declared in a package specification and must be defined in the package bodyReceived on Tue Oct 03 2000 - 15:38:20 CDT