Home » Developer & Programmer » Reports & Discoverer » Lexical Parameter problem with Oracle Reports Builder
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!
Previous Topic: How to distinguish each copy of a report from the others?
Next Topic: Input parameters
Goto Forum:
  


Current Time: Tue Nov 26 11:14:47 CST 2024