Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

search pattern in clob passed as an argument

user8525647Dec 27 2016 — edited Dec 28 2016

Hi,

I am getting a clob input as IN parameter to a function. I need to do a pattern search in it, but when i use regexp_instr it gives me error:

" string literal too long".

What is the correct way to do it?

Thanks

This post has been answered by Gbenga Ajakaye on Dec 27 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 25 2017
Added on Dec 27 2016
7 comments
1,029 views