hello guys!!! I'm newbie in hibernate and my english very bad. But I'll try it.

I need run a query with a stored function. The stored function is :

CREATE OR REPLACE FUNCTION Civ_Genera_Xml_PROFE (PID_PROFESIONAL PROFESIONALES.ID_PROFESIONAL%TYPE,
PUSUARIO VARCHAR2,
PCODERROR OUT NUMBER,
PTEXTERROR OUT VARCHAR2
)
RETURN NUMBER
IS


my question is: How I can do to mapping the create query into hibernate?? I see the query has 4 params


I have this code in the mapping document:

<sql-query name="altaProfesionalCivitas" callable="true">
<query-param name="pid_profesional" type="java.lang.Long"/>
<query-param name="pusuario" type="java.lang.String"/>
<query-param name="pcoderror" type="java.lang.Long"/>
<query-param name="ptexterror" type="java.lang.String"/>
{ call Civ_Genera_Xml_Profe() }
</sql-query>

but I can't if it is correct...

And finally, I can't how is the code into the Dao, how call the function mapped?

Thanks

nobody help me? :-(

Maybe this might help, see my third post here:

http://forum.hibernate.org/viewtopic.php?t=976888