PLS-00225: subprogram or cursor 'string' reference is out of scope
- From: "xiaoyan" <xiaoyezi.xyz@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 4 Sep 2006 17:01:25 +0800
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!
Other related posts:
