<div>
Mirror the value of the field to an item in another block (say Control block) and try to use this field (:control_block.field_name<wbr />) in the procedure.
</div>


Mirror the value of the field to an item in another block (say Control block) and try to use this field (:control_block.field_name) in the procedure.

<div>
Tried this and form hung.<br />
set the value in 'query data source arguments' to the control block item. Dump message &nbsp;was Last Builtin: EXECUTE_QUERY - (Successfully Completed), but the procedure was never executed. Tried several times and had to kill most sessions.
</div>


Tried this and form hung.
set the value in 'query data source arguments' to the control block item. Dump message  was Last Builtin: EXECUTE_QUERY - (Successfully Completed), but the procedure was never executed. Tried several times and had to kill most sessions.

<div>
<div class="content wysiwyg-content">
Can anyone tell me how to pass a block items' value into a procedure the block is based on.<br />
I've tried putting the item name in the arguments properties but it appears to pass null. If I replace this with a hard value of say 99 it passes this fine.<br />
<br />
The block is based on the procedure that looks like this.<br />
It returns a ref cursor and this works fine without the in parameter.<br />
<br />
PROCEDURE p_query_payees (pv_where_clause IN VARCHAR2,<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; prc_payees_rows IN OUT grefcur_payees);<br />
<br />
blah blah.<br />
<br />
Thanks<br />

</div>
</div>


Can anyone tell me how to pass a block items' value into a procedure the block is based on.
I've tried putting the item name in the arguments properties but it appears to pass null. If I replace this with a hard value of say 99 it passes this fine.

The block is based on the procedure that looks like this.
It returns a ref cursor and this works fine without the in parameter.

PROCEDURE p_query_payees (pv_where_clause IN VARCHAR2,
                          prc_payees_rows IN OUT grefcur_payees);

blah blah.

Thanks


Forms 6i. Block Based on procedure. Parameter passing

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.