Re: Another JDBC driver bug (a piece of *)

OK.
Using the default db that comes with Oracle9i installation on an NT. SQL:
SELECT *
FROM OE.warehouses
WHERE rowNum < 18
-- this tbl has five columns, of which two uses UDDT

SQL*Plus type of SQL client again no problem in returning resultset.

JDBC err msg:
[Oracle JDBC Driver][Oracle]ORA-00600: internal error code, arguments: [koksghds1], [], [], [], [], [], [], []

SQL SELECT * FROM OE.warehouses WHERE rowNum < 18 DATASOURCE Oracle9i_testDS
VENDORERRORCODE 600
SQLSTATE HY000 Please note:
query against another table using SQL*Plus failed, however this tbl contains both UDDT and BLOB data

SELECT *
FROM PM.PRINT_MEDIA
WHERE rowNum < 18;

but it return meaningful err
"SP2-0678: Column or attribute type can not be displayed by SQL*Plus"

rs_arwar_at_hotmail.com (Rauf Sarwar) wrote in message news:<92eeeff0.0301071935.c767132_at_posting.google.com>...
> qwert12345_at_boxfrog.com (Doug Baroter) wrote in message news:<fc254714.0301071249.68e55457@posting.google.com>...
> > Check out this simple query against an Oracle9i db:
> > select *
> > from OE.CUSTOMERS
> > where rowNum <100 + 1
> > order by CUSTOMER_ID DESC
> >
> > SQL+Plus type of SQL client can handle it while interface via JDBC
> > driver for Oracle9i fails (sorry don't know its version, likely the
> > most recent one).
> >
> > Possible cause:
> > some columns uses UDDT (User Defined DataType), e.g. cust_address uses
> > a UDDT named "cust_address_typ", I guess when SQL+Plus detects it it
> > does translation/conversion while the "simple-minded" JDBC driver just
> > throws up her hand, what a crying baby!
>
>
> It would be helpfull if you provide the JDBC error message before
> rudely accusing it of failure.
>
> /Rauf Sarwar
Received on Wed Jan 08 2003 - 19:58:12 CET