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);