The secret of how to be miserable is to constantly expect things are going to happen the way that they are "supposed" to happen.
You can have faith, which carries the understanding that you may be disappointed. Then there's being a willfully-blind idiot, which virtually guarantees it.
Mike Keith wrote:Or... you could JPA and make use of vendor extensions that are easy to use and consistent with the programming model. (How's that for a sales pitch )
Mark Spritzler wrote:
Mike Keith wrote:Or... you could JPA and make use of vendor extensions that are easy to use and consistent with the programming model. (How's that for a sales pitch )
Are the caveats of;
One and only one out parameter and it must be the first parameter and it must be a RefCursor?
Thanks
Mark
Mike Keith wrote:
Mark Spritzler wrote:
Mike Keith wrote:Or... you could JPA and make use of vendor extensions that are easy to use and consistent with the programming model. (How's that for a sales pitch )
Are the caveats of;
One and only one out parameter and it must be the first parameter and it must be a RefCursor?
Thanks
Mark
Sorry, I don't understand your comment. You should be able to have as many OUT parameters as you want. If you want an output cursor then you can only have one of those, but any number of output params, and at any place in the stored proc.
Well to be vendor specific, this is a caveat in Hibernate in calling Stored Procedures. And as far as I know today before Hibernate 3.5 (haven't used it yet) the caveats still exists.
Mike Keith wrote:Stored procs are certainly on my wishlist for the next version. I obviously can't make any promises as to what ends up in the spec, though. The final product is the result of a maze of expert group twists and turns, inputs and requirements, preferences and abhorrences...
kri shan wrote:
Anyone please tell me how to execute this stored procedure through hibernate (in Java)?
Thread question is about Hibernate, not about JPA related issues.
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime. |