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
ASKED: March 30, 2009  8:39 PM
UPDATED: March 30, 2009  8:45 PM

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following