I have a challenge with Oracle Adf 10g and Oracle Database 10g project im currently working on.
I need to send a db table type with values from Excel file to plsql procedure.
I'm using struct and array descriptor to achive that.
Problem emerges when i try to send a null value.
Function getArrangedRow determines values to be sent in and returns Object.
Some of the values in array are sometimes null which then produces error
java.sql.SQLException: Inconsistent java and sql object types
Is possible and how to send null values with Object array to db?
Thanks in advance!