Hi wM Users!
I have a strange problem when trying to insert a byte array into a database, if the size of the byte array exceeds 2000 bytes (approximately).
I use an InsertSQL adapter (against an Oracle database), where the input column for the blob has BLOB as column type, BLOB as JDBC type, and byte array as Input field type.
I use pub.string:stringToBytes in order to transform a string (string of an xml file) into a byte array. This byte is the input for the InsertSQL service.
Inserting works fine up to a size of ~2000 bytes. After that I got the following oracle error message back:
ORA-03120:two-task conversion routine: integer overflow
However, I do not really know what to do with the description for that error (see: http://ora-03120.ora-code.com/).
Does anyone know, how I can set the buffer length? Or any other remedy for this problem?