I saw this on the forums. Does it not work?
CallableStatement st = null;
ResultSet rs = null;
st = session.connection().prepareCall("{call ? := ...}");
st.registerOutParameter(1, OracleTypes.CURSOR);
st.setObject(2, optionalID);
st.execute();
rs = (ResultSet)st.getObject(1);
- Andres
-----Original Message-----
From: Max Rydahl Andersen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 15, 2004 1:53 PM
To: March, Andres
Cc: [EMAIL PROTECTED]
Subject: Re: [Hibernate] Oracle stored procedures
Hello Andres,
Tuesday, June 15, 2004, 5:49:06 PM, you wrote:
> I was wondering if there is any progress being made ongetting
> Oracle stored procedures working with hibernate CRUD queries.� I
> wouldlike to help out in this area if possible.� One of the things I
> would like tobe able to do is specify one of the out parameters to
> be used as the resultset.
Hibernate3 has support for CUD operations in stored procedures.
R as in Read has not been implemented as at the moment the team
haven't found a good way (read standard) to get a out parameter as a
resultset.
Do you know a way ? ;)
(note: it actually seems like Oracle is the only major player who
don't have proper out parameter as resultset support - which I find
kind of weird ;)
/max
> �
> -----------------------------------------
> Andres March
> Platform - Apps Engineering
> Sony Online Entertainment
> desk: 858.577.3373
> cell:�� 619.519.1519
> �
--
Best regards,
Max mailto:[EMAIL PROTECTED]
-------------------------------------------------------
This SF.Net email is sponsored by The 2004 JavaOne(SM) Conference
Learn from the experts at JavaOne(SM), Sun's Worldwide Java Developer
Conference, June 28 - July 1 at the Moscone Center in San Francisco, CA
REGISTER AND SAVE! http://java.sun.com/javaone/sf Priority Code NWMGYKND
_______________________________________________
hibernate-devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hibernate-devel
