This content has been marked as final. Show 2 replies
Thanks for you response. I am using dbms_lob.compare statement in the where clause.
SELECT COUNT(*) INTO ln_check_patternexists FROM ods_cpath_masterpatterns WHERE dbms_lob.compare(patterncode, lv_patterncode) = 0;
Its working fine.
Thanks and Regards
Edited by: Nagaraja Akkivalli on Apr 27, 2011 10:22 PM