Execute WITH Clause Statement with PL/SQL Developer

[RoGGeR]

Hi Guys,

I am trying to use the Oracle WITH Clause, but I have problem executing this simple statement:
WITH stmnt AS (SELECT dummy FROM dual)
SELECT dummy FROM stmnt;

returns no rows ...

If I execute this statement in an anonymous block or sqlplus everything is Ok. I am using PL/SQL Developer 7.1.5.1397 and maybe I have to enable something within the client.

 

[Marco Kalter]

This may indicate that you are using an old Oracle Net version that does not know the WITH command.