Any1 know of a Java tool (class) that will do this?

"This" is:

• Given a PL/SQL package that returns an untyped REFCURSOR, interrogate the cursor via JDBC and get all column names and their datatypes.
• List them out into a script file to be used to create an Oracle Object Type.

Just on the off-chance any1 has already "been there done that" so I don't have to re-invent boiled water...

TIA

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam