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
- 1791 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is a Trigger ?
What are the unrestricted procedures used to change the popup screen position during run time ?
Where is the external query executed at the client or the server?
What is the built-in used for showing lov at runtime?
How can we call a URL from a menu (Oracle Forms 6i)?
In what situation u create the BPA.
How can a break order be created on a column in an existing group?
What is term? What is use of term?
What is an implicit anchor and how is it a different form explicit anchor in a report builder?
Can you attach an lov to a field at design time?
How to create LOV in Oracle forms?
What are the different display styles of list items?
Oracle General 
