Re: dbms_defer package invalid in Oracle 8.1.7

From: <Winnie_Liu_at_infonet.com>
Date: Tue, 3 Oct 2000 13:51:08 -0700
Message-Id: <10638.118402@fatcity.com>

Isn't the package body is in the file format *.plb?

I checked one of the 8.0.X database that I have, it is called prvtdefr.plb

Winnie

"Tom Pall" <tom_at_cdproc.com>@fatcity.com on 10/03/2000 02:40:35 PM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

Subject: 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 body

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Tom Pall
  INET: tom_at_cdproc.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Oct 03 2000 - 15:51:08 CDT