When a Search for Use is done on a prompt object, the following error message(s) pop up:
U0020568 Runtime error in object 'XREPLACE_RENAME(ACT)', line '00095'. DS return code: '0000003590 DB error: 'OCIStmtExecute', 'ERROR ',*,
'ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 4092, maximum: 4000)*. Error occurred in UCDSFUN at position: 'DS_SEARCH15'.
This is a bug that was observed in version 9. If an insert is done from a CLOB field to a CHAR field, the function to_Char is called on Oracle. This function can only handle < 4000 bytes.
If the String that is searched for is more than 4000 characters long, an error like above is returned. This behavior has been fixed in Version 10. In previous versions, please use Strings that are less than 4000 characters long for the Search for Use.