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(error)
8.2.x(error)
8.1.x(error)
8.0.x(error) 
7.3.x(tick)
7.2.x(tick)
7.0.x(error)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(tick)
Microsoft SQL Server(tick)
CSS3(error)
CSS2(tick)
CSS1(error)
Details
  1. 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().
  2. XML Extract and XMLSequence functions are NOT supported, nor are links (of type "rely on") to built-in type XMLType.
  3. 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