If your CLOB's size is less then 32K you may write it by dbms_lob.write into varchar2 and make your pattern matching with varchar2, or if it's possible, split your lob into smaller varchar2 pieces and math them. You may also write some java procedure.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.