Hi,
I think this "eval" like approach is not working (execute immediate
is running in other context - so you cannot access dynamically to
variables, unless you use USING clause with EXEC. IMMED. and there you
need to write down parameter )
I also think if you reveal a bit more about problem, there may be
way with execute immediate by other approach
( and if somebody shows you this eval approach I will be highly
ashamed and learn another new thing =) )
hoppo
On 27. 10. 2010 14:25, oldyork90 wrote:
I have a name, collected from a view. This name is a string,
(varchar2), and is a name of a var. I want the value of the var
named by this name.
If you know something like perl, it would look like this:
$myvar = 5;
$nameof = 'myvar';
$x = eval $$nameof
I think execute immedate is in play here, but all my attempts fail. I
can't get it to evaluate the name and return the value of that
variable.
Thank you.
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en