[color=green]hi all,
Im new to hibernate.
im using hibernate 3.2.6
im able to call simple stored procedure in oracle 10g like procedure returns a curser from single table.
but my requirement is i need to call a complex stored procedure...
like it has 6 IN parameters and 1 OUT parameters and those IN/OUT parameters are not belongs to single TABLE. those parameters are related to some other tables.
based on those IN parameters Some calculations/logic are done in Procedure.

so how can i invoke these kind of Stored Procedure Using XML Mapping file(Hibernate Mapping).

Thanx in advance...
[/color]