This content has been marked as final. Show 2 replies
I tried to reproduce your problem but couldn't. I created an Interactive Report with the following query:
See the example here: http://apex.bhawke.com/apex/f?p=104:7
select object_name, object_type, decode(object_type, 'PACKAGE BODY', 'This is a package body.', 'This is something else.') "remarks" from user_objects order by 1
user = demo
pass = demo
When you search for text in the "decode" column (Remarks) it works ok.
Let me know if I'm missing something.
Thank you Keith Malay.its working fine ..by the way your sample application is not working constantly. plz retrieve it could be helpful to some one.