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 -> Re: PL/SQL Tables accross Schema's

Re: PL/SQL Tables accross Schema's

From: <jkstill_at_teleport.com>
Date: 1997/12/01
Message-ID: <34821557.6939568@news.teleport.com>#1/1

On Sat, 29 Nov 1997 00:36:17 GMT, martinb_at_SPAM-OFF-hooked.net (martin) wrote:

>I've tried, but get PLS 382 - Expression of wrong type... Looks like I need to
>define the destination variable as 'a.package.function%TYPE' (it self not
>doable) by defining that variable as the original PL/SQL Table record type in
>the package (which of course is not describable accross schema.).
>

Have you tried it? You can see those across schemas if you make them available in the package header.

 I have an application that depends on that very ability.     

Jared Still
Oracle DBA and Part Time Perl Evangelist ;) jkstill_at_bcbso.com - work
jkstill_at_teleport.com - home Received on Mon Dec 01 1997 - 00:00:00 CST

Original text of this message

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