• Post Reply Bookmark Topic Watch Topic
  • New Topic

Sending null value to db  RSS feed

Kre So
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello all!
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!
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!