Re: Arrays iin PL/SQL

You didn't mention which version of PL/SQL you are using.

Forms 4.5 and Procedure Builder are built on PL/SQL version 1.1. This version does not have any built in array handling. Version 2.0 of PL/SQL has PL/SQL Tables, which are basically arrays. I'm not sure if this version of PL/SQL will be in the WebForms release of Forms, but it is supposed to be in release 2.0.

As for referencing a variable by name, you can do this in Forms using NAME_IN and COPY. I don't think you can do this directly in PL/SQL though.

I hope this helps,
Shawn

EDB <edbis_at_pacific.net.sg> wrote in article <01bbd387$de6187c0$724e78cb_at_ppp.ncs.com.sg>...
>
>
> Hi,
>
> I'm writing a PL/SQL program and would like to know if there's anyway of
> using an array concept in PL/SQL just like in other lang.
> If yes, how to do that? Can I also do such thing in PL/SQL, e.g.
>
> variable1, variable2, variable3 , ...etc is variables defined as
> varchar.
>
> in my PL/SQL pgm, can I have such code?
>
> For T in 1 .. 3 loop
>
> tmp := 'variable' || T;
> test := tmp;
>
> end loop;
>
> would like tmp to refer to the variable, i.e. variable1, variable2,etc.
> How can I do that in PL/SQL?
>
>
> Appreciate your help.
>
>
> TIA ....
>
>
> Mun Kong
>
Received on Mon Nov 18 1996 - 00:00:00 CST