Oracle stored procedures and Hibernate

[Durin Dal]

I am working on a project (JSF web app running against an Oracle database) for a client and evaluating Hibernate for use with it, but the client requirement database-wise is that only stored procedures be used, even for CRUD operations on a single table. Does using Hibernate in this scenario even make sense? One can use Hibernate to execute stored procedures (in DAOs or whatever), but it appears that the Hibernate object mapping uses SQL syntax only and can't use stored procedures, from what I've read so far. If I'm off-base, then some pointers in the right direction would be appreciated. :-T

Thanks in advance...

[Bhagat Singh Rawat]

Here is the solution of your's problem:Stored Procedures with Hibernate