Win a copy of The Way of the Web Tester: A Beginner's Guide to Automating Tests this week in the Testing forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Sending null value to db

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!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic