-
Title
Error during installation: "ORA-04063: package body 'schema.QU_VERIFY' has errors" or "ORA-06550: -
Description
Trying to install Quest Code Tester and receive one of the following errors:
"ORA-04063: package body schema.QU_VERIFY has errors".On reviewing the log it indicates an error with package QU_OUTCOME_XP and QU_VERIFY. The qu_install.log shows the following:
QU_OUTCOME_XP (PACKAGE BODY) is not valid
Line 2444 Position: 25 Text: PLS-00597: expression 'L_RETURN' in the INTO list is of wrong type
Line 2442 Position: 7 Text: PL/SQL: SQL Statement ignored
QU_VERIFY (PACKAGE BODY) is not valid
Line 2941 Position: 28 Text: PLS-00597: expression 'L_TEMP' in the INTO list is of wrong typeor
ORA-06550: line 2, column 14:
PLS-00201: identifier 'QU_VERIFY_PACKAGE.VERIFY' must be declared
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored
Line 2937 Position: 10 Text: PL/SQL: SQL Statement ignored -
Cause
Attempting to install backend repository on a 9.2.0.1 or 9.2.0.5 database. The minimum requirements for Code Tester are an Oracle 9.2.0.6 server and client.
-
Resolution
Upgrade Oracle database and client to 9.2.0.6