I am able to create a data block based on stored procedure.
but I want that procedure to take input arguments as well and I am facing the issue while setting the value for that input arguments from another block item.
Please somebody help, How to set the value for input argument from another control block- item?.(Note :Data block is based on the stored procedure)
Thanks Daniel. Now It it is working fine.
Initially I have given the value like this NVL(:BLOCK.ITEM,1) so it has been converted to 'NVL(:BLOCK.ITEM,1)';
Now i changed to :BLOCK.ITEM but it is not converted.
It is working fine. thanks a lot