As far as I know substitution variables (&) are used in SQL*Plus domain,
and don't work in PL/SQL scope (many times I wish the did)
and bind variables bind themselves (as I mentioned by use of USING
clause) by they fully specified name
I don't see any way to dynamically access PL/SQL variables, you can only
dynamically access SQL stuff (tables, views,... using select, insert,...)
hoppo
On 27. 10. 2010 15:41, Gopakumar Pandarikkal wrote:
Do some study on substitution variables (&) and bind variables (:).
One of them will work for you
Regards
Gopakumar. Pandarikkal
On Oct 27, 2010 6:40 PM, "Andrej Hopko" <ado.ho...@gmail.com
<mailto:ado.ho...@gmail.com>> wrote:
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 ...
--
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
--
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