Applying "TRANSLATE" function on a large Text. String Operations on a CLOB
S_27Jul 11 2011 — edited Jul 12 2011Hi All,
Here is the SQL query that I am using....
SELECT TRANSLATE([TEXT], '{}*:/=-', ' ') as TEXT2 FROM DUAL;
Where [TEXT] value comes a different program. We wrote the above query thinking TEXT would be always less than 4000 characters. But it is exceeding 4000 characters and results in following error
java.sql.SQLException: ORA-01460: unimplemented or unreasonable conversion requested
Could you help me in fixing this?
-S