Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> PLS-00225: subprogram or cursor 'string' reference is out of scope

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

From: xiaoyan <xiaoyezi.xyz_at_163.com>
Date: Mon, 4 Sep 2006 17:01:25 +0800
Message-ID: <001801c6d000$b68b7cd0$d88870ca@buaad538c81ca1>


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 Mon Sep 04 2006 - 04:01:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US