I'm issuing a sql statement from cold fusion using the 9i syntax:

with
q1 as (select .....),
q2 as (select .....),
select * from q1,q2 where q1.x = q2.x

This is a simple example but when cf sends the query, 0 records are returned. When I cut and paste the query as it shows in debug mode and paste it into sqlplus, I get records returned.

Is there something with jdbc/CF/something else that would cause this query to return 0 records?