REGEXP_REPLACE

Database
Fan

REGEXP_REPLACE

I am attempting to use this library function to replace an occurance of a text string similar to OREPLACE. The issue I am having is that the output string appears to be limited to only 8000 characters, even thought the search string is greater than that. I get the 9134 error, "Result exceeds the output argument size limit."

I need to serach and replace strings as large as 30000 bytes (characters).  How does one go about modifying the function to return larger string (varchar) sizes?

Tags (1)

Accepted Solutions
Junior Contributor

Re: REGEXP_REPLACE

Try to CAST(your_input_column AS CLOB) and the cast the result back to a VarChar.

1 ACCEPTED SOLUTION
2 REPLIES
Junior Contributor

Re: REGEXP_REPLACE

Try to CAST(your_input_column AS CLOB) and the cast the result back to a VarChar.

Fan

Re: REGEXP_REPLACE

Thank you for your reponse, that did the trick, I appreciate the help.