| ORA-01036: illegal variable name/number [message #140522] |
Tue, 04 October 2005 10:48 |
 |
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
|
Senior Member |
|
|
Hi everybody,
I’m getting the following error while commenting out the sql dynamically in Reports from Applications.
ORA-01036: illegal variable name/number
I have 4 select statements with union all. I want to comment out the un-required sql’s depending on some conditions. So I have created 8 lexical parameters and assigning them either ‘/*’ or ‘*/’ to them. For some conditions it is working fine and for some other it is throwing the above error.
I couldn’t find any reason/solution for that. Can anybody throw some light?
Thanks in adv.,
Vamsi.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
