Solution ID: prim80752
Errors for PROCEDURE ADMUSER.PV_OPEN_PROJECT:
Status: Reviewed
Version(s): 6.2.1

Fact: Oracle 9i is not a tested configuration for P6.2.1 and the (:= set) statement is not recognized by Oracle 9i.
Problem:

Errors for PROCEDURE ADMUSER.PV_OPEN_PROJECT:
Problem: When upgrading from P6 to P6.2.1 manually on an Oracle 9i platform the orpm_src.sql script fails to compile
Problem: Upgrade fails on projidlist := set(projidlist); or projid_array := set(projid_array);
Problem:

Warning: Procedure created with compilation errors


Errors for PROCEDURE ADMUSER.PV_OPEN_PROJECT:


112/17   PLS-00103: Encountered the symbol “SET” when expecting one of the following:       ( – + case mod new not null <an identifier>     <a double-quoted delimited-identifier> <a bind variable> avg     count current exists max min prior sql stddev sum variance     execute forall merge time timestamp interval date     <a string literal with character set specification>     <a number> <a single-quoted SQL string> pipe  The symbol “SET” was ignored. 

Fix: Upgrade the Project Management schema using a tested Oracle Version. 

For a list of tested configurations of the P6.2.1 Suite, refer to the following solution:  Solution ID:  prim77535  Tested Configurations for 6.2.1