Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:3.3.1.GA
Name and version of the database you are using:
Oracle 9i

Does anyone have a method to deal with cases where Ref Cursor is the last parameter? For example:

PROCEDURE GetUserAccountSP ( p_userId IN VARCHAR2,
cur_ACCOUNTS OUT T_CURSOR)
IS
BEGIN
OPEN cur_ACCOUNTS FOR
SELECT * FROM ACCOUNTS
WHERE user_id = p_userId;
END GetUserAccountSP ;

I have quite a few of these stored procedure and am having some trouble with the hibernate mapping since the first parameter in the mapping

{ call MYPKG.GetUserAccountSP (?, :userId) }

is reserved as an output parameter which will not work for me. If some one has a solution to this please let me know.

Thank you in advance
Read this: http://hibernate.org/42.html

I assume I will need to create a custom persister? Can someone at least guide me in the right direction?

I know its not the cleanest solution but you could try write a wrapping function that has the return param at the first position.



Also, i hope that was only a simplified example and not real code because thats what queries are for in Hibernate

etc

Thanks pkleindl, I started down that road but there are too many stored procedures and they are quite complex. This may become a maintenance issue so I was looking for something a little cleaner.
Yes, this is definitely a simple example and by no means an actual stored procedure.
I am attempting to write a custom persister but find myself overriding too many methods for such a simple task.
Any other suggestions will be deeply appreciated.

Any other suggestions to making the ref cursor the last parameter vs the first. I am working on a project where there are over 200 stored procedures and it will be very tedious to create wrappers for all of these stored procedures.

Thank you in advance.