Purpose
The PL/SQL Analyzer displays the following warning message during analysis: the schema-table '<qualified table name>' cannot be imported into the Knowledge Base because it is an object table.
Tables of XMLType (create table <table name> of XMLType) are not analyzed by the PL/SQL Analyzer. They will appear in the Object Manager of the PL/SQL Analyzer wizard, however, when selected for analysis, it will throw the above error
The PL/SQL syntaxes not supported in the 7.3 and 7.2 version of the CAST-AIP are listed below.
Applicable in CAST Version
Release | Yes/No |
---|---|
8.3.x | |
8.2.x | |
8.1.x | |
8.0.x | |
7.3.x | |
7.2.x | |
7.0.x |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS3 | |
CSS2 | |
CSS1 |
Details
- XML extensions are not supported by the PL/SQL Analyzer. However, certain functions are supported: XMLElement, XMLAttributes, XMLForest, XMLColAttVal, XMLConcat (in the version that takes a list of XMLElements as a parameter) and the aggregate function XMLAgg().
- XML Extract and XMLSequence functions are NOT supported, nor are links (of type "rely on") to built-in type XMLType.
- Tables of XMLType (create table <table name> of XMLType) are not analyzed by the PL/SQL Analyzer. They will appear in the Object Manager of the PL/SQL Analyzer wizard, however, when selected for analysis, the PL/SQL Analyzer displays the following warning message during analysis: the schema-table '<qualified table name>' cannot be imported into the Knowledge Base because it is an object table.
Notes/comments
Related Pages