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
- 1 Answers
- 1792 Views
- I also Faced
- E-Mail Answers
Answer Posted / Anil Kumar Bharti
Unfortunately, you cannot directly use a SELECT statement with bind variables in Oracle Forms Reports due to some limitations in the Oracle Forms runtime environment.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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
