I am using NATINE SQL,
EXEC SQL .
CONNECT TO 'FRAXION'
SET CONNECTION 'FRAXION'
. EXEC SQL.
EXECUTE PROCEDURE InsertERPUpload (IN :'1', IN :'Supplier', IN :'DGB001',IN :x_xmldoc )
The issue is the x_xmldoc defined as string gets to big, and we get 32k limit issue.
Error analysis A data object is larger than 64 KB, or an internal table is wider than 64 KB. 1. The length of a data object in a Native SQL command must not exceed 64 KB. This situation only occurs if a large type C field (larger than 32767 characters) is used in a Unicode system. 2. If an internal table is used in a Native SQL command, the defined width of the table must not exceed 64 KB.