|Re: Possible to return a ref cursor from Oracle function using StoredFunctionCall? [message #735629 is a reply to message #557099]
||Wed, 12 October 2011 12:31
| Neikius Mising name
Registered: April 2011
No real name wrote on Sat, 04 September 2010 06:31|
Is it possible to use StoredFunctionCall to execute an Oracle stored function that returns a ref cursor? I've not been able to find any information on how this can be done. I've written the following sample code but it fails to work (getting a "PLS-00306: wrong number or types of arguments" error despite my arguments being correct). The failure occurs on "session.executeQuery(query)".
StoredFunctionCall call = new StoredFunctionCall();
ValueReadQuery query = new ValueReadQuery();
I have to add that I have executed the "my_function" Oracle function successfully using plain JDBC and OracleCallableStatement so I can confirm the function is fine. I have also switched "dateFrom" and "dateTo" from "java.util.Date" to "java.sql.Date" as I thought perhaps these were causing the error but it didn't make a difference.
Unfortunately there are no real solid examples of how to return a ref cursor from an Oracle function using StoredFunctionCall. Can any help and give me pointers? Thanks in advance.
Still not possible or what? Why have "StoredFunctionCall" then? I can do this using "select function() from dual" and then resultset.next();rs=(ResultSet)resultset.getObject(1) to get the real result set... but this way I cannot map the ResultSet to the @entity. Darn.
edit: Also, sorry for "necroing" but I cannot find any useful resources on this, teh same as OP.
[Updated on: Wed, 12 October 2011 12:32]
Report message to a moderator
Powered by FUDForum
. Page generated in 0.10002 seconds