Hi All,

Can anyone provide some information about using nested oracle tables with hibernate.

I have table which has a column which is again a table. I don't know how the mapping is done in hibernate for this type of scenario.

The table structure is as follows

TAG_UD NUMBER NULL,
TAG_TYPE VARCHAR2(10) NULL,
REP_INC REP_UD_COLLEC NULL (this that column)


the above mentioned column is created as follows

CREATE TYPE REP_UD_COLLEC AS TABLE OF NUMBER
GO

the query to fetch data looks something like below.