Hello.

I'm using some native queries in my EJB 3.0 project.

When I write a native query like
INSERT INTO SOME_TABLE VALUES (:val0, :val1, :val2) and use the executeUpdate() method of the Query interface after assigning all parameters to values other than null everything works OK.

However, if I let any of the values be null (even though that exactly what I want to put in the database) I get the following exception:

...
java.sql.SQLException: ORA-00932: inconsistent datatypes: expected NUMBER got BINARY
...

Is there any way to go arround this? I really must write the nulls to the database.

Thanks in advance,

Hugo Oliveira
hugom.oliveira.ext@siemens.com