JDBC Receiver

[Former Member]

Hi,

I'm having a structure where I use Execute and therefore have the standard parameters.

<Parameter1>

IsInput=true

Type=CHAR

I have two similar interfaces, one which works fine but the other one gives me an error since it's much larger: A column or character expression is larger than the max size.

I'm putting the whole xml file into a clob so I guess that the file is too big but I don't know how to allow more space.

I know that when using CHAR it's limited to 64k and if the file is unicode it could be twice as big.

Does anyone know if it's the datatype I need to change or is it any parameter I need to give in the JDBC CC? like 'sqlBindMode' = true?

Appreciate the help!

[Former Member · Accepted solution]

Hi Sonny,

You may specify the datatype as CLOB.

Please check below link:

[http://help.sap.com/saphelp_nw73/helpdata/en/44/7b72b2fde93673e10000000a114a6b/content.htm]

Regards,

Beena.

[Former Member · Accepted solution]

´Thanks! that solved the error. I hade used BLOB previously but it didn't work so I never tried CLOB.

Best regards