Kevin Seneviratne wrote:
>
> I am running PL/SQL 2.3.2.2.0, SQL*Plus 3.3.4.0.0 and Oracle 7.3.2
>
> My problem is as follows
>
> create or replace x(
> y as varchar2
> )
> cursor c_z
> select aaa from cccc
>
> .....
>
> works fine
>
> but the moment I try
>
> select aaa from bbb.ccc
>
> it comes up with an error.
>
> Is there anyway to specify the schema inside a stored procedure
>
> Thanks vmuch
>
> Kevin.
I had this problem, too. You can get around it by explicity granting
the privilege to the user accessing the procedure.
For example: 'grant select on bbb.ccc to user' (you have to be running
this statement logged on as bbb)
Then create the procedure again. Hope this helps.
jackie marino
wgp
Received on Fri May 29 1998 - 12:41:20 CDT
