hi every body
im using Hibernate 3.0.5 / Oracle 10g to execute a stored Proc
i do it exactly as the example test in the Cvs Repositoy
but i alwas get the oracle error 17003 Invalid Column Index
** the mapping
<sql-query name="paramhandling" callable="true">
<return-scalar column="value" type="long"/>
<return-scalar column="value2" type="long"/>
{ call paramHandling(?,?) }
</sql-query>
** the Oracle stored proc
Create Procedure paramHandling (i IN INTEGER, j IN INTEGER) As ...
** the java code
Query namedQuery = sess.getNamedQuery("paramhandling");
namedQuery.setLong(0, 10);
namedQuery.setLong(1, 20);
try {
List list = namedQuery.list();
Object o[] = (Object[]) list.get(0);
assertEquals(o[0], new Long(10));
assertEquals(o[1], new Long(20));
}
catch ...
i tryed the samea test with Sybase 12.5 it works fine
does any one know why it doesn't work and if there any workarround
Thank you
|