1
Invalid objects after upgrade from 8.1.7.4 to 10G
for the following procedure within a package: PROCEDURE GET_ALL_REGIONS(rs_REGION_LIST OUT r_REGION_LIST, Vrc2_err_msg OUT VARCHAR) IS BEGIN OPEN rs_REGION_LIST FOR SELECT DISTINCT(PRS_REGION) INTO r_REGION_LIST FROM SET_PARISH_RFT; Vrc2_err_msg:=NULL; RETURN; EXCEPTION WHEN OTHERS THEN Vrc2_err_msg:=SUBSTR(SQLERRM,1,200); RETURN; END GET_ALL_REGIONS; I am getting this error. pls-00321: expression ‘R_REGION_LIST’ is inappropriate as the left hand side of an assignment statement PL/SQL: [...]
Answer Question
| March 30, 2009 8:39 PM
ORA-00904, Oracle 10g, Oracle error messages, Oracle upgrades, PL/SQL, PLS-00321, SQL
for the following procedure within a package: PROCEDURE GET_ALL_REGIONS(rs_REGION_LIST OUT r_REGION_LIST, Vrc2_err_msg OUT VARCHAR) IS BEGIN OPEN rs_REGION_LIST FOR SELECT DISTINCT(PRS_REGION) INTO r_REGION_LIST FROM SET_PARISH_RFT; Vrc2_err_msg:=NULL; RETURN; EXCEPTION WHEN OTHERS THEN Vrc2_err_msg:=SUBSTR(SQLERRM,1,200); RETURN; END GET_ALL_REGIONS; I am getting this error. pls-00321: expression ‘R_REGION_LIST’ is inappropriate as the left hand side of an assignment statement PL/SQL: [...]
Answer Question
| March 30, 2009 8:39 PM
ORA-00904, Oracle 10g, Oracle error messages, Oracle upgrades, PL/SQL, PLS-00321, SQL
1
