Getting reference from a newly inserted object

HI
I am troubling in getting reference of an user defined type after inserted it into a table.
For example, I use a java program to insert an user defined object:

.
.
.

OraclePreparedStatement pstmt =
(OraclePreparedStatement)conn.prepareStatement ("insert into My_Table values (?)");
pstmt.setObject(1,this);
pstmt.execute();
.
.
.

I can't use another select statement (ex. select ref(myref) from My_Table where My_Table.ID=?) to retrieve the record just inserted due to there is no constraint on all the columns of My_Table. Please help to get the reference of a newly inserted object, thanks a lot. Received on Fri Jan 06 2006 - 09:27:48 CST