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: create dynamic variables

Re: create dynamic variables

From: Martin T. <bilbothebagginsbab5_at_freenet.de>
Date: 9 Aug 2006 08:51:52 -0700
Message-ID: <1155138712.287954.104050@n13g2000cwa.googlegroups.com>


mgmonzon wrote:
> Hi Everybody,
>
> Is posible to create dynamic variables in a PL/SQL procedure?
> (snip)
> Sample :
>
> Create or replace read_variables as
> Begin
> for reg in (select VAR_NAME, VAR_VALUE from TABLE_VARIABLE ) loop
> <create variable defined in the field VAR_NAME in TABLE_VARIABLE> ;
> <Assign value using the field VAR_VALUE in TABLE_VARIABLE> ;
> End Loop ;
> End ;
>
> Is possible do that?
>

No. This is not possible. (As in all other programming languages I know.)
Why would you want to do such a thing? It doesn't make too much sense too me :-)

best,
Martin Received on Wed Aug 09 2006 - 10:51:52 CDT

Original text of this message

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