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

Home -> Community -> Usenet -> c.d.o.server -> PL/SQL schema problem

PL/SQL schema problem

From: Kevin Seneviratne <kevins_at_connect.com.au>
Date: Thu, 28 May 1998 18:21:04 +1000
Message-ID: <356D1E70.D073333@connect.com.au>


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

Original text of this message

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