Hi,

I just wanted to know what would be the correct way, through hibernate, to call an Oracle function where there are multiple SELECTS to multiple tables and returns a single VARCHAR2 value. I've seen a number of ways to do this such as with NamedQueries (annotations and XML configuration), or use the doWork method from the Session. Is there a best-practice? If so, please let me know with an example.

Thanks,

Juan

I had a similar situation so I used clob but you can definitely used varchar2(32656). Hope this helps

Function function_name
returen varchar2 (or use clob)
is

ret_val varchar2(32656) or ( user retval clob);
begin
.. your code here

return retval;
end;