Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Mon Sep 04 2006 - 04:01:25 CDT