1 reply to this topic

[Vlodik Myslony]

Hi,
Has anyone succeeded in using the "WITH" Clause within your imbedded sql in ProIV.

I am currently using Proiv 6.2 on Oracle 10g.
The ProIV trace file shows the SQL being parsed correctly but proIV returns the old 366 Oracle SQL error.


SQL
WITH subquery_name AS (the aggregation SQL statement) SELECT (query naming subquery_name);
ENDSQL

[Richard Bassett]

I have never tried that, however, I would *guess* that there might well be a problem with PROIV not recognizing this as a SELECT statement at all because it doesn't actually start with "SELECT". It might just never have come up before and might be pretty easy for PROIV to fix.

I assume it works correctly (albeit with lower performance potentially) if you do it the old fashioned way repeating the aggregation subquery within the body of the select?