X-Abuse-Report: abuse@teranews.com Message-ID: Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!newshosting.com!news-xfer1.atl.newshosting.com!209.50.230.160.MISMATCH!news.astraweb.com!news-small.astraweb.com!newsfeed.mountaincable.net!newsfeed-east.nntpserver.com!nntpserver.com!TeraNews!not-for-mail Date: Mon, 05 May 2003 13:14:49 GMT Lines: 27 From: "Steve Long" Newsgroups: comp.databases.oracle.server References: Subject: Re: Any1 know of a Java tool (class) that will do this? X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Xref: core-easynews comp.databases.oracle.server:185305 X-Received-Date: Mon, 05 May 2003 06:14:23 MST (news.easynews.com) Look at java.sql.ResultSetMetaData This package provides the column names and data types of the result set in a java.sql.ResultSet cursor. To generate a script, you would have to write a java print routine. "Noons" wrote in message news:Xns9372DD11EA225Tokenthis@210.49.20.254... > "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