Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Genereic reference type in PL/SQL?
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
![]() |
![]() |