Problem with setNull and JBC OCI driver

[TyzA]

Hi there,

I have an application running on SilverStream 4 with an Oracle9i database behind it.
When I try to execute a callablestatement with setNull (eg. cstmt.setNull(14,Types.NULL) I get the "java.sql.SQLException: Invalid column type" error message.
When I change to setNull to setString(14,"" it does work.
But since the application is using it this many, I was wondering if there is a fix or another way to do it.

Thanks for the feedback.

regards,
T.

 

[sedj]

Is the table field allowed to be null ?

 

[TyzA]

Yes,
It's allowed to be null.

With a previous version of Oracle (Oracle 8i) there was no problem.

 

[sedj]

If the exact same code worked for 8, but not for 9, then maybe consult the db vendor and docs, or talk to the DBA ...