Originally posted by Will Way:
No where in the docs they have mentioned that hibernet 3.0 doesn't support stored procedures with more than one out parameters.
It is my impression that hibernate treats a procedure with a single OUT parameter in the first position like a
function where the return value is equivalent to that first parameter, while the second procedure parameter becomes the first function parameter, etc. Basically
actually returning an OUT parameter in
Java would require the use of "Holder" objects (which is actually done in
Java Web Services) which is a level of complexity which Hibernate is attempting to avoid at this point. You may actually save yourself some grief by defining these "procedures" explicitly as functions. If you really need to "return" multiple parameters you may need to resort to storing those parameters/results in DB-session variables and access them subsequently through additional helper functions.
[ June 05, 2006: Message edited by: Peer Reynders ]