"maxmike" <maxmike_at_imag.net> wrote in message
news:1108946879.561439.114840_at_z14g2000cwz.googlegroups.com...
> When will Oracle ever support JDBC properly?
> If I try this:
> prepstat = conn.prepareStatement(sqltext);
> meta = prepstat.getMetaData();
> I get an ORA-01003 (no statement parsed) error.
> This works well with other JDBC drivers, and is a very important
> feature if you are trying to find out what types of data your execution
> would emit without actually having to execute on a mega-row table to
> find out. Like for example if you have complex expressions and want to
> preview if a union is possible. Geez, Oracle.
Just add a clause so the query returns zero records, i.e. WHERE 1=0 or
something to that effect.
Received on Sun Feb 20 2005 - 20:06:21 CST
