Invalid objects after upgrade from 8.1.7.4 to 10G

5 pts.
Tags:
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: ORA-00904:: invalid identifier PLS-00321: expression 'R_VIOLATION_DESCRIPTIONS' is inappropriate as the left hand side of an assignment statement PL/SQL: ORA-00904:: invalid identifier I have not pinpointed wich exact question to ask. It looks like the select into statement is created correctly and that you are still allowed to use ref_cursors. Any suggestions would be greatly appreciated. thanks Kim

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: