Re: PL/SQL Tables accross Schema's

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1997/12/01
Message-ID: <34833b66.11055917@inet16>#1/1

Say you have USERA who owns:

create package a_pkg
as

   type array is table of varchar2(2000);    function something return array;
end;

And you have USERB that wants to call it... USERB would then code:

declare

    x USERA.A_PKG.ARRAY;
begin

    x := usera.a_pkg.something;
end;
/

USERB must use USERA's type....

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

>Hi,
>
>has anyone had any success defining a packaged function that returns a PL/SQL
>table of VARCHAR2(2000) in schema 'a' and calling that function from schema
>'b'.
>
>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.).
>
>I'd really like to avoid creating a temp table if anyone has any ideas,
>
>TIA
>
>Martin
>
>martinb_at_removeforspam.hooked.net
>
>Technomation, Inc.
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD  

http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Mon Dec 01 1997 - 00:00:00 CST