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?

  • REGEXP_REPLACE
Tags (1)

Accepted Solutions
Senior Apprentice

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
Senior Apprentice

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.