Skip to Content
-1
Feb 05, 2021 at 07:01 AM

Native SQL,

92 Views

I am using NATINE SQL,

EXEC SQL .

CONNECT TO 'FRAXION'

ENDEXEC.

EXEC SQL.

SET CONNECTION 'FRAXION'

ENDEXEC

. EXEC SQL.

EXECUTE PROCEDURE InsertERPUpload (IN :'1', IN :'Supplier', IN :'DGB001',IN :x_xmldoc )

ENDEXEC.

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.