Exporting from Oracle 7.3.4 to 8.1.7.3

From: Andrew <apomphre_at_sewl.com.au>
Date: 23 Apr 2002 17:01:28 -0700
Message-ID: <5165d4a0.0204231601.2fd2036a@posting.google.com>

Hello, We have successfully exported our 7.3.4 database to 8.1.7.3, except for one package, the error is below, any ideas? Thanks Andrew

SQL> alter package wa_trace compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors package body fisdba.wa_trace; Errors for PACKAGE BODY FISDBA.WA_TRACE:

LINE/COL ERROR

-------- -----------------------------------------------------------------
7/16     PLS-00498: illegal use of a type before its declaration
7/16     PL/SQL: Item ignored
42/1     PL/SQL: Item ignored

42/35 PLS-00206: %TYPE must be applied to a variable, column, field or

         attribute, not to "WATRC_VALVE"

222/8 PL/SQL: Statement ignored
222/11 PLS-00320: the declaration of the type of this expression is

         incomplete or malformed

240/1 PL/SQL: Item ignored
242/18 PLS-00206: %TYPE must be applied to a variable, column, field or

         attribute, not to "WATRC_VALVE"

371/4 PLS-00320: the declaration of the type of this expression is

         incomplete or malformed

371/4 PL/SQL: Statement ignored
374/4 PLS-00320: the declaration of the type of this expression is

         incomplete or malformed

374/4 PL/SQL: Statement ignored
377/4 PLS-00320: the declaration of the type of this expression is

         incomplete or malformed

377/4 PL/SQL: Statement ignored
380/4 PLS-00320: the declaration of the type of this expression is

         incomplete or malformed

380/4 PL/SQL: Statement ignored
383/4 PLS-00320: the declaration of the type of this expression is

         incomplete or malformed

383/4 PL/SQL: Statement ignored
SQL> spool off Received on Tue Apr 23 2002 - 19:01:28 CDT