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