Formula to retuen Object

biso · **Joined:** Wed Feb 07, 2007 8:26 pm **Posts:** 17

Dears,

Is it possible to use formula to return Object.

For example:
I need to have the last Order in Product->*Order (One-to-Many) relation.

I did the following:

Code:

<one-to-one name="lastOrder" class="Order"  >
            <formula>    
            (select * from Order o2 where o2.id = 128)
            </formula>
</one-to-one>

This returns: ORA-00913: too many values error.

Any ideas?
Thanks in advace
Abbas

mmerder · **Posted:** Tue Nov 10, 2009 4:12 am

Try to select only the id instead of "*".

biso · **Joined:** Wed Feb 07, 2007 8:26 pm **Posts:** 17

Dear mmerder,

Thanks a lot for your response.
I will try this but will all fields get populated on the first access?

Thanks again
Abbas

mmerder · **Posted:** Wed Nov 11, 2009 4:54 am

Depends on how you have mapped Order (lazy/eager fields).