How to call a db function from hibernate

[Viswanath Sriram]

Hi,
Can any one tell me how to call the database function from hibernate.

[Mark Spritzler]

Yes, you can used what is called a Named QUery, where in an xml file you create the call to the stored procedure, you will include ? to allow you to pass in the parameters.

Here is one big caveat.

There can only be one out parameter and it must be the first parameter.

Mark