Issue: ORA-22835 Error During Ship Confirmation in Batch Form

Problem:

Error while loading batch values: ORA-22835: buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 5403, maximum: 4000) 

Solution:

This error occurs during ship confirmation from the batch form in ShipConsole or integrated Oracle Cloud apps. The root cause is a delivery containing a serialized list that exceeds 4000 characters, which exceeds the limit for a standard VARCHAR2 or STRING type in Oracle.

• Oracle Limitation: Standard STRING or VARCHAR2 types can only handle up to 4000 characters.

• When a serial number list exceeds this limit, the system attempts to convert the data into a format it cannot handle, triggering the ORA-22835 error.

This issue was partially resolved earlier during the shipping process by changing the data type from STRING to CLOB on the cloud application side.

However, the error reappears during batch processing because the web service integration layer still uses the STRING data type.

Final Fix:

• Update the data type from STRING to CLOB in the web services layer that handles batch ship confirmations.

• This ensures that large serial number lists can be processed without hitting the character size limitation.