CMS Snapshot Analysis - Run Analyzer - Warnings - Oracle Server PL SQL with Core CAST AIP - Syntax error - AS OF

 The page details out syntax Error when analyzing an Oracle offline extraction due to the "AS OF " statements, for example :

CREATE OR REPLACE VIEW ROGPUBRND1_MCQ."FDC_VIN" ("ID_FDC","LIBELLE","CODE_FONCTION","CODE_GROUPE","CATEGORIE")
AS SELECT "ID_FDC","LIBELLE","CODE_FONCTION","CODE_GROUPE","CATEGORIE"
FROM ROGPUBND.FDC as of scn to_number(userenv('client_info'))

CASE 1:

CREATE OR REPLACE VIEW ROGPUBRND1_MCQ."FDC_VIN" ("ID_FDC","LIBELLE","CODE_FONCTION","CODE_GROUPE","CATEGORIE")
AS SELECT "ID_FDC","LIBELLE","CODE_FONCTION","CODE_GROUPE","CATEGORIE"
FROM ROGPUBND.FDC as of scn to_number(userenv('client_info'))

These syntax errors are received due to the use of "AS OF" clause in the from clause.

This syntax is implemented starting oracle 10G and is not supported by CAST till version 7.2.5.
Starting 7.2.6 the extractor has been improved to take this clause into account as well.

Workaround:
Not to use this "AS OF" syntax.

CASE 2:

SELECT LISTAGG(column, separator) WITHIN GROUP(ORDER BY column) FROM table

Syntax error received due to LISTAGG and PIVOT used in the query:

LISTAGG and PIVOT/UNPIVOT are syntaxes used to concatenate or aggregate the data contained in columns.
The point of interest here is the call to the columns, not the semantics of LISTAGG and PIVOT as they are only about data presentation.

Workaround:

1) select  LISTAGG (column, separator) WITHIN GROUP (ORDER BY column)) FROM table
with the following :
select column from table 

2) select * from table UNPIVOT INCLUDE NULLS (...) 
with the following :
select * from table

This issue has been permanently fixed in 8.2.3

Webcall : 28484

CASE 2 : Ticket  # 7628, 7629, 7630