Re: "No ResultSet set was produced" error when using JDBC

On Wed, 06 Apr 2005 08:45:58 -0700, htran interested us by writing:

> Hans,
> Thanks for responding so quickly.
>
> Server: Oracle9i Enterprise Edition Release 9.2.0.3.0
> jdbc:oracle:thin
>

Not 100% sure, but iirc 'WITH' is not supported in the 9i thin driver. (There are a lot of improvements in the 10g thin driver.)

The differences between the thin and oci drivers are well documented - check out the "JDBC Developer's Guide and Reference" at docs.oracle com, or directly at

http://www.oracle.com/pls/db92/db92.docindex?remark=homepage

To troubleshoot this (after verifying a simple select from dual works), I'd start by trimming the statement down to a single WITH.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***