Re: JPA Calling an Oracle function with OUT parameter
- From: Stanimir Stamenkov <s7an10@xxxxxxxxxxxx>
- Date: Thu, 12 Jun 2008 16:49:32 +0300
Thu, 12 Jun 2008 16:29:39 +0300, /Stanimir Stamenkov/:
Query query = em.createNativeQuery("{ ? = "
+ "call MY_FUNCTION(?,?,?,?,?,?,?) }");
query.setParameter(1, null); // XXX: registerOutParameter ?
query.setParameter(2, ...);
...
query.setParameter(7, ...);
List result = query.getResultList();
I don't know how I can register (and later get) the first parameter as OUT parameter, pretty much like one could do with JDBC (java.sql.CallableStatement), and I'm getting an exception as:
java.sql.SQLException: Missing IN or OUT parameter at index:: 9
The last line actually states:
java.sql.SQLException: Missing IN or OUT parameter at index:: 8
The "index:: 9" comes from an experiment I've made adding one more ",?" to the function parameters, but seems no matter how many question marks I add it always asks for an additional OUT one. If I don't add additional ",?" and try to set:
query.setParameter(8, ...);
I get an "java.lang.IndexOutOfBoundsException: Remember that ordinal parameters are 1-based!" at that line.
--
Stanimir
.
- Prev by Date: PostgresQL 55000 error
- Next by Date: Re: JPA Calling an Oracle function with OUT parameter
- Previous by thread: PostgresQL 55000 error
- Next by thread: Re: JPA Calling an Oracle function with OUT parameter
- Index(es):
Relevant Pages
|
