Beginner |
 |
Joined: Wed Dec 14, 2005 10:32 am Posts: 20
|
Is there any sample java code for calling a function that returns a sys_refcursor?
I have a stored procedure like this:
CREATE OR REPLACE FUNCTION Batch_Process ( p_active_dt IN DATE,p_truncate IN CHAR)
RETURN Types.cursor_type
AS
st_cursor Types.cursor_type;
.....
END Batch_Process
and the Mapping
<?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping> <class name="com.telcove.phoenix.picc.dao.common.PICCRecord" dynamic-insert="false" dynamic-update="false"> <id name="correlationID" type="string" > <generator class="increment"/> </id> </class> <sql-query name="Sp_Pic" callable="true"> <return class="com.example.Record" /> {? = call SpBatch_Process (?,?) } </sql-query> </hibernate-mapping>
any help is greatly appreciated.
-Ram
|
|