java - Call an Oracle Stored Function that returns a user defined type with Hibernate -

java - Call an Oracle Stored Function that returns a user defined type with Hibernate -

i have encountered problem hibernate, spring , oracle other day : how can phone call stored function returns user defined type (oracle object) hibernate.

i started thinking i'dd build entity defines oracle user type problem have no existing table map function name. tried making basic query don't know how exploit returned object.

here's source code :

-- main function create or replace function "ecommerce"."nombrecommandesperiode" (v_datedebut date, v_datefin date) homecoming t_commandes_periode v_nombre_commandes number; v_nombre_commandes_non_livrees number; v_nombre_commandes_impayees number; begin select coalesce(count(c.id), 0) v_nombre_commandes commande c c."date" >= v_datedebut , c."date" <= v_datefin; v_nombre_commandes_non_livrees := commandesnonlivrees(v_datedebut, v_datefin).count; v_nombre_commandes_impayees := commandesimpayees(v_datedebut, v_datefin).count; homecoming t_commandes_periode(v_nombre_commandes, v_nombre_commandes_non_livrees, v_nombre_commandes_impayees); end; / -- returned type create or replace type "ecommerce"."t_commandes_periode" object ( nombretotal number, nombrenonlivrees number, nombreimpayees number ); /

how can phone call function hibernate able work java object reflects t_commandes_periode user defined type ?

i give thanks who'll seek help me problem of mine :).

java sql spring oracle hibernate