Answer Posted / Bhajan Veer Singh

To call a SQL query in an After Parameter form, you need to create a new block with the cursor that contains your query. Then, use the Open_cursor procedure to execute the cursor and assign its results to a variable or control.

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

2227