Hi,

We are using Hibernate in our web applications and I have few questions, need some help from hibernate experts.

1. Can Hibernate handle multiple (Oracle) cursors?
2. Can Hibernate handle an Oracle cursor with IN OUT parameter? As per the Hibernate doc, the first parameter must be 'OUT' for any ref cursor. Does it mean that we can use a ref-cursor with 'IN' parameter?

My situation is that my app needs to communicate with DB in two ways; (a). Pass the result set to application and (b). Receive the modified data to be stored in DB, how can it be accomplished using Hibernate.

Any tip/help/suggestions will be greatly helpful

Thanks a bunch.

I am also interested in this post. I did see this post, but it wasn't really related to an in and an out, just two outs.

2 outs seem like more of a problem than 1 in and 1 out...

It would have been nice if the post referenced to would have pointed to some documentation. Could you point me to the documentation where you found that the ref cursor out had to be the first parameter?