fixing stored procedures after upgrading from 9.2 to 10
We recently moved to a new server and upgraded the Oracle version form 9.2 to 10 in the process. All went well until we tried to compile a stored procedure that used a user defined type.
The type is defined with:
create or replace TYPE V_RF_ARRAY ;
Then in the procedure declared with:
fh sa.v_rf_array := sa.v_rf_array('x');
which gets the following when compiled:
Error(34,4): PLS-00311: the declaration of "V_RF_ARRAY" is incomplete or malformed
Since it worked fine on 9i I am assuming there is a change required for 10 but nothing tells me what.
create or replace TYPE V_RF_ARRAY ;
Then in the procedure declared with:
fh sa.v_rf_array := sa.v_rf_array('x');
which gets the following when compiled:
Error(34,4): PLS-00311: the declaration of "V_RF_ARRAY" is incomplete or malformed
Since it worked fine on 9i I am assuming there is a change required for 10 but nothing tells me what.
0