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" <wizofoz2k_at_yahoo.com.au.nospam> wrote in message
news:Xns9372DD11EA225Tokenthis_at_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_at_yahoo.com.au.nospam
Received on Mon May 05 2003 - 08:14:49 CDT
