Hi all,
I am trying to set the "default where " clause dynamically using set_block_property builtin .My code likes this....
set_block_property(blk_id, default_where,'VW_CASEADDRESS_CASEMAIN.CSM_CASENO'||' '||'like'||' '||'(:CTRBLK.CASE_NUMBER%)');
The Error says "Unable to fetch records" and its not identifying "%"........it says invalid character.
Can anybody please solve it.
Thanks
saritha