Hibernate 3.1.3
Oracle 9i

I would like to convert some existing JDBC routines to Hibernate. One type is a function that accepts 2 arguments and returns a CLOB and the other type is a PreparedStatement that accepts a varchar and a CLOB and of course returns nothing.

I have the Hibernate In Action Book by Manning, but do not see any section that deals with this. Upon some good searches I see people using a <sql-query call in their mapping, but sometimes searches can be mis-leaading.

I am looking for the best approach to make function calls and PreparedStatement calls with Hibernate. Looking for docs, etc. or possibly a section in the book that I cannot find.

Thanks,