ORA-01704: string literal too long - Migration

In 4.6 - We are stoing xmldata into one field and the field type is Long in oracle. (inserting the xmldata using pub.db.insert service). Its working fine for large xmldata content too)

In 6.5 - The same service we migrated to 6.5 using Jdbc adapter service. Because pub.db.insert is deprecated. For Less xmldata, adapter service is working fine. But large xmldata content its throwing following error.

Adapter Runtime (Adapter Service): Unable to invoke adapter service and ORA-01704: string literal too long " ORA-01704: string literal too long

Is there any way to avoid this error without changing the database scripts(datatype change for particular field)

Can you please guide me to solve this Issue?

For inserting large xmldata content you have to change the datatype either BLOB or CLOB.I know you are not looking for datatype change, but i guess this is the only way you have to handle large xmldata insert to DBase.


A search of the web for ORA-01704 turned up this: http://ora-01704.ora-code.com/

Thanks!. I will look into it and let you know the update.