Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> PL/SQL schema problem
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. Received on Thu May 28 1998 - 03:21:04 CDT
![]() |
![]() |