Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> dbms_defer package invalid in Oracle 8.1.7

dbms_defer package invalid in Oracle 8.1.7

From: Tom Pall <tom_at_cdproc.com>
Date: Tue, 3 Oct 2000 15:38:20 -0500
Message-Id: <10638.118399@fatcity.com>


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 body
Received on Tue Oct 03 2000 - 15:38:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US