WITH-Clause : PL/SQL Beautifier could not parse text

[orca777]

Hi dev team, the with clause seems not to be supported by the beautifier. Version : current 7.0.3 production release. database oracle 10.2;

WITH Common_Tradingsystems AS (
  SELECT Ts.Tradingsystemkey
    FROM Company                Com,
         Company_Tradingsystems Lt,
         Tradingsystem          Ts
   WHERE Lt.Parentobject = Com.Id
     AND Com.Id = '489EFB639D7E4BEAA60C11B07B826CC1'
     AND Lt.Property = Ts.Id
  INTERSECT
  SELECT Ts.Tradingsystemkey
    FROM Company                Com,
         Company_Tradingsystems Lt,
         Tradingsystem          Ts
   WHERE Lt.Parentobject = Com.Id
     AND Com.Id = '98C33E116F35B84BA92411112B607694'
     AND Lt.Property = Ts.Id)
SELECT Lt1.Property         AS Source_Tradingsystem,
       Ts1.Tradingsystemkey AS Source_Tradingsystemkey,
       Lt2.Property         AS Target_Tradingsystem,
       Ts2.Tradingsystemkey AS Target_Tradingsystemkey
  FROM Company_Tradingsystems Lt1,
       Tradingsystem          Ts1,
       Company_Tradingsystems Lt2,
       Tradingsystem          Ts2
 WHERE Lt1.Parentobject = '489EFB639D7E4BEAA60C11B07B826CC1'
   AND Ts1.Id = Lt1.Property
   AND Ts1.Tradingsystemkey IN
       (SELECT Tradingsystemkey
          FROM Common_Tradingsystems)
   AND Lt2.Parentobject = '98C33E116F35B84BA92411112B607694'
   AND Ts2.Id = Lt2.Property
   AND Ts2.Tradingsystemkey IN
       (SELECT Tradingsystemkey
          FROM Common_Tradingsystems)
   AND Ts1.Tradingsystemkey = Ts2.Tradingsystemkey

Greetings
Karl

 

[Marco Kalter]

Is this as a standalone SQL statement in the SQL Window or as part of a PL/SQL program?

 

[orca777]

Hi Marco,
as a standalone SQL in the SQL Window i get the Parse warning but not in the PL/SQL Editor.

Karl