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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Genereic reference type in PL/SQL?

Re: Genereic reference type in PL/SQL?

From: William Robertson <williamr2019_at_googlemail.com>
Date: 14 Oct 2006 04:48:33 -0700
Message-ID: <1160826513.405100.67760@f16g2000cwb.googlegroups.com>

Thomas Blankschein wrote:
> Hello,
>
> > Why do you think you need pointers in PL/SQL? What's the task at hand?
>
> At first it is a quite academic question, if it's possible at all. The
> task where this came to my mind was a package which uses two arrays
> internally. Both arrays hold different data, but the interface is the
> same. So I thought about adding a second parameter to the functions and
> procedures which tells what array I want to use.
> I tried substituting the two independend arrays with an array of arrays
> where I can use the index directly, but it gave me several strange
> errors during use. So I returned to the two array solution.
>
> Thomas

Why not just pass both arrays into the procedure as IN OUT NOCOPY parameters, or am I missing something?

PL/SQL does referencing implicitly for IN parameters. For example see here:
http://tkyte.blogspot.com/2006/10/something-new-i-learned-this-week.html Received on Sat Oct 14 2006 - 06:48:33 CDT

Original text of this message

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