Hibernate version: 3.0 beta

Hi I'm currently working on Hibernate 3.0 beta version. I've a problem implementing Stored Procedures. I'm unable to give mapping for a stored procedure which retrieves data.Any help wud be appreciated...Any example cud be appreciated...Thanks in advance....

we don't have SP query support yet

may be the cusomt SQL feature helps

HTH
Ernst

I've seen the code something like this...

<sql-insert callable="true">{call createPatient (?, ?, ?, ?)}</sql-insert>

which are custom sql statements...is there any other way for calling stored proce...vth the above syntax we can only insert/update/delete..but I've a SP which retrieves data...how can i do that? plz help...

read my last answer - it says it all ,)

We don't have SP query support yet

Hi Madhavi,
You can do one thing,
create a temporary table (using sql statement) which holds the columns returned by the SP.and call SP
for eg
create table temp column ....
insert into temp execute your SP

then when you call this you will be getting a List of that temp table instances