Oracle WITH Statement not working

[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

 

[Marco Kalter]

This is most likely an Oracle Client version issue. The client needs to be 9.0 or later. Earlier versions do not know of the WITH statement.

 

[Stella]

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

 

[Marco Kalter]

It might indeed be a home issue. Can you go to Help > Support Info, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?