Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:3

Hello,
I'm trying to call a procedure from my Oracle database.
In my mapping file, there is :

<sql-query name="procName" callable="true">
{ call PROC_MY_PROC(?,?) } </sql-query>

And in my java code :

List list = session.getNamedQuery("procName")
.setInteger(0, id)
.setString(1, p)
.list();

When i'm tying to execute I'm having this error :

Hibernate: { call PROC_MY_PROC(?,?) }
17/06/2008 10:49:41 org.hibernate.util.JDBCExceptionReporter logExceptions
ADVERTENCIA: SQL Error: 1006, SQLState: 72000
17/06/2008 10:49:41 org.hibernate.util.JDBCExceptionReporter logExceptions
GRAVE: ORA-01006: bind variable does not exist

Does anybody has an idea ?
Thanks in advance !

Hello again,
i found a wqay which works..
In the mapping file i've set callable="false"

<sql-query name="procName" callable="false">
{ call PROC_MY_PROC(?,?) } </sql-query>

and then in the java code :
int res = session.getNamedQuery("procName")
.setInteger(0, id)
.setString(1, p)
.executeUpdate();

Like this is working.

Sweet! Thanks for posting back with the solution. It helps everyone that hits this posting through Google or something.