Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!news-out.nuthinbutnews.com!propagator2-sterling!news-in-sterling.newsfeed.com!newsfeed.zip.com.au!spool01.syd.optusnet.com.au!spool.optusnet.com.au!not-for-mail Newsgroups: comp.databases.oracle.server Subject: Any1 know of a Java tool (class) that will do this? From: Noons Organization: Completely disorganized, but still kicking! Message-ID: User-Agent: Xnews/5.04.25 Date: 05 May 2003 11:45:38 GMT Lines: 18 NNTP-Posting-Host: 210.49.105.124 X-Trace: 1052135138 1304 210.49.105.124 Xref: core-easynews comp.databases.oracle.server:185298 X-Received-Date: Mon, 05 May 2003 04:49:34 MST (news.easynews.com) "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@yahoo.com.au.nospam