I don’t know If anyone has had this problem. I’m using Datastage sw to read an Oracle table with fields SDO_GEOMETRY and write another table with these fields.

I’m using the package SDO_UTIL and particulary when I read a sdo_geometry field I use SDO_UTIL.TO_WKTGEOMETRY utility that convert the field in LongVarchar while when I have to write the field I use SDO_UTIL.FROM_WKTGEOMETRY to convert the field again in SDO_GEOMETRY.

The problem is with the conversion utility FROM_WKTGEOMETRY when the field is a NULL SDO_GEOMETRY. In this case I get a Java Exception.

Does anyone have any solution to handle NULL SDO_GEOMETRY fields?

Thanks
Luca