RE: PLS-00225: subprogram or cursor 'string' reference is out of scope

From: Mercadante, Thomas F \(LABOR\) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Tue, 5 Sep 2006 08:55:01 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF6815CA@EXCNYSM0A1AJ.nysemail.nyenet>

Xiaoyan,  

Yes this is a priv problem. "Grant select on test.courses to king;"  

Tom  

---

This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments.

---

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of xiaoyan Sent: Monday, September 04, 2006 5:01 AM To: oracle-l_at_freelists.org
Subject: PLS-00225: subprogram or cursor 'string' reference is out of scope  

Hi,all:

  When I connect Oracle database with a user(such as wxy/wxy),and then in the declare part of my procedure,I make the following definition: ('test':a name of schema;'courses'is name of a table in schema'test')

  rec test.courses%ROWTYPE;

it is ok,but when I connect database as another user such as (king/king) and make the same definition,I got the error:PLS-00225: subprogram or cursor 'string' reference is out of scope ,Then why?Does the user 'king'need to be granted any privilige? what privilige?  

Thank you in advance!

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Sep 05 2006 - 07:55:01 CDT