in user parameter property we have list of values.can we
write select query for binding?
for example::
select empno from emp where deptno=:deptnum
:deptnum is first parameter it displays distinct dept nos.
if i do like this it is giving error::
bind variables are not allowed in the select statement
- 0 Answers
- 1289 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Can a field be used in a report wihtout it appearing in any data group?
Name of the functions used to get/set canvas properties?
What is the difference between keystartup and pre-form ?
What Enter package procedure does ?
if u have one group can u create another from that
What is the difference between a POST-FIELD trigger and a POST-CHANGE trigger ?
How can we expand Parameter Form Canvas on Reports 6i?
How can I sum column wise in Oracle excel report?
What is the difference between flex mode and confined mode?
I developed on form as per my requirement,and register that one in apps custom_top.But the problem is ,if you open the form but not closed,I founded why this is error is comming ,the custom_top is not supported my form . I need any one your help in advicing me...what I do the custom_top supported the forms.
What is a difference between pre-select and pre-query?
HI in report builder am creating paramters.for that i have taken emp table from scott user . in deptnum am displaying distinct deptno.if i select dept 10 ,empnum drop down should display empno's of deptno 10. .if i select dept 20 ,empnum drop down should display empno's of deptno 20.for this wat i have to do.
Oracle General 
