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!
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!