Hi,

I would like to know, how to pass a NULL value to a Stored Procedure (Oracle) as a parameter?

The stored procedure wait for several parameters, one of them is a Date wich is the one that can have a NULL value.

Oracle 9i
Hibernate3.1

Thank Stef-âne

.setDate(x, null) ? (like any other query)

Hi, thank for the reply, but I does not work...

I call a Stored Procedure ModifFinPrev(?,?,?,?) with 4 parameters.

<sql-query name="ModifFinPrev" callable="true">
<return-scalar column="resultat" type="integer"/>
{ ? = call pkg_tournees.ModifFinPrev(?,?,?,?) }
</sql-query>

I trace the 4 parameters that I pass to the Oracle Store procedure:

PARAMETRE_0 SP: [(A)_TOTO]
PARAMETRE_1 SP: [10428]
PARAMETRE_2 SP: [2006-08-20 00:00:00.0]
PARAMETRE_3 SP: [null]

When I call it ,I expect a SQL Exception: like:

org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could not execute query; bad SQL grammar [{ ? = call pkg_tournees.ModifFinPrev(?,?,?,?) }]; nested exception is java.sql.SQLException: ORA-06550: line 1, column 13:
PLS-00306: wrong number or types of arguments in call to 'MODIFFINPREV'

this is an oracle/jdbc specific error - not hibernate.

I think so, but before I try several other drivers, Oracle thin, Weblogic ,...
and same error!

A second possibility is a Spring Bug, because I use it with the Hibernate 3 :HibernateDaoSupport.

thank