Hi,

We had SQLsever 200 Database .We need to use hibernate newly.
while i am using hibernate to call stored procedures , i observed that stored procedures with select queries are working fine.
But, i had faced a problem while using the stored procedure with insert and update queries having both in the same stored procedure and by depending on the existance of the record(by Id), either insert or update queries will be called.
How can i call this SP using hibernate.Example: SP NAME: AddUserDetails(?,?,?).
The input parameters are userid,date,language.

Quick and detailed explanation with example is appreciated.