I am using Hibernate Version 3

Accessing an Oracle 10g database.

In the project I am currently working on, I need to call a stored procedure which returns an Oracle object type and then persist this for the application.

I have set up the userType using a mixture of http://www.hibernate.org/261.html and Java Persistence with Hibernate.

I have also set up a sql-query to call the stored procedure within my mapping document which, itself, is called from within a DAO.

The issue I have is in mapping the returned object type to a class as I do not have a table to reference, nor do I have an id column. I keep getting an "wrong number or types of arguments in call to" error when I call the stored procedure which - I'm pretty confident in saying - is down to how I have mapped the class and return type.

In short, I would like to know how to map the class without having to use an id column, or whether there is some other method I could use instead of class.