Re: converting string to variable in PL/SQL... how do I do it?

if you're coding OracleForms there is the name_in()-Function returning varchar2:

declare

   item_name varchar2(YY);
   item_value varchar2(XX);

   my_num      number;
   my_date     date;

   item_name := function_that_returns_the_name_of_a_variable    my_value := name_in( item_name );

• and now to_<what_ever_you_need>
• predefined or self-written functions my_num := to_number( item_value ); my_date := to_date( item_value ); end;

J Crowder <jcrowder_at_shout.net> schrieb in im Newsbeitrag: 3AD38A06.E89B7A68_at_shout.net...
> I have a varchar thats holds the name of the variable I want to use.
> How do I tell the.
>
> mystring := function_that_returns_the_of_a_variable;
>
> how do I use mystring now to retrieve whats in the variable who's name
> was returned?
>
> Thanks
>
> J crowder
>
Received on Wed Apr 11 2001 - 08:31:55 CEST