PB with factoring subquery

[r2363c]

this query work in SQL*plus
with C as (select * from emp)
select * from C

but not in PL/sql dev
but this one (very similar) yes
select * from (
with C as (select * from emp)
select * from C
)
I think it's a bug on factoring subquery handling.

I've just downloaded the last realease of pl/sql dev.

Do you have the same behavior ?
because I fear it was a NET8 issue ?
However in metalink someone got the same issue with TOAD.

Thanks,
Laurent

 

[Marco Kalter]

Works fine for me on Oracle9i 9.0. What is your client/server version? What is the error message?

------------------
Marco Kalter
Allround Automations

 

[r2363c]

I've just tested on 9i, that's work too.
But on 8.0.5 client, it doesnt work.
on 8.1.6 it doesn't work too.

no error message, just no row !!!
But on sql*plus 8.1.6 it give
SP2-0642: SQL*Plus internal error state 2091, context 0:0:0
Unsafe to proceed

it's really stange !!!

 

[Marco Kalter]

I think that Oracle Net 8.x and earlier do not recognize this as a select statement.

------------------
Marco Kalter
Allround Automations