Lexical Parameter problem with Oracle Reports Builder [message #151557] |
Thu, 15 December 2005 09:30 |
kakeez
Messages: 2 Registered: December 2005
|
Junior Member |
|
|
Hi,
In the query of the report, want to do something like:
Select
&lex_var my_alias,
... .....
FROM
....;
Now when lex_var, a bind variable is defined as:
:lex_var = 'statement I want'
I have an error saying 'my_alias' is undeclared identifier.
However with
:lex_var = 'statement I want my_alias,'
it works. Please help as I need to make it work the first way!
|
|
|