Thanks Marco for your prompt response.
I'm actually using 10.2. I've came across a similar post on the Web saying it may be an Oracle Home issue. Does this ring true to you?
Thanks
Stella
Hi
The Oracle WITH statement returns nothing in PL/SQL Developer
eg
WITH dual_rec AS (SELECT COUNT(*) FROM dual)
SELECT * FROM dual_rec
Has anyone any ideas what may be causing this?
Thanks v. much
Stella
