Hi,

I need to call many Stored Procedures in the application (mostly get data procedures). The application uses Spring, Hibernate (with annotations), JSF and Oracle. Could someone let me know the best way to access stored procedures.

1. Using Spring w/o using Hibernate (even though application has it)
2. Using Spring and Hibernate (using Hibernate to access stored procedures)

I would like to know Pros/Cons of above approach

Next,I have seen some examples using procedure access with Hibernate but most of them were simple single table single POJO example. Can someone please share example of framework for the real application scenario - I have one procedure with cursor output having 10 columns from 5 different tables + I have 10 such procedures.

Rocker

Anyone ?