| oracle report parameters problem [message #143358] |
Thu, 20 October 2005 02:14  |
raja_v
Messages: 1
Registered: October 2005
|
Junior Member |
|
|
Hi ,
I have a requirement here in oracle reports.
As such we have 2 inputs to the report .
for example Country (Input 1) , place (Input 2) .
And the the list for the input 2 (place) changes with respect to the country (Input 1)
Currently i am using an sql for the input Country (P_1).
and retrieving the second input using bind variables ( select place from table where country = :P_1)
,but ended up in getting error .
REP-00781 - Bind Variables are not allowed in the Select statement.
Do we have any other to get this done .
This is an urgent requirement . Would appreciate some quick resolutions to this . Please help me to get some inputs on this issue .
Thanks & Regards
Raja
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
