Empty CLOB field value from Oracle database using JDBC Sender

[dharamveer_gaur2]

Hi All,

I am selecting a CLOB field from Oracle database table using JDBC Sender adapter and getting error "NullPointerException"

Seen SAP note 1283089 but its not applicable for my support pack PI 7.0 SP 12 and client dont want to upgrdate SP 17 right now.

I tried rpad(1,0)Column_Name funciton in JDBC select query but it selcting blank value for every record even those having some value for this CLOB field so not useful

Could anybody suggest possible way? client dont want to change anything at database side.

Thanks,

Dharamveer

[Former Member]

What is the Oracle driver version installed? You might need to install 10.x driver if not already using it.