Links
Comment on page

MSCEWI1065

Columns from expression not found

Severity

Medium

Description

This error happens when the columns of a Select Expression were unable to be resolved, usually when it either refers to a Type Access whose reference wasn't resolved or a column with a User Defined Type whose columns haven't been defined; such as a Type Without Body or Object Type with no columns.

Example Code

Input Code (Oracle):

--Type without columns
CREATE TYPE type1;
--Another valid type without columns
--CREATE TYPE type1 AS OBJECT();
CREATE TABLE table1
(
column1 type1
);
SELECT
column1
FROM table1;

Output Code:

-- ** MSC-ERROR - MSCEWI1057 - CREATE TYPE WITHOUT BODY VARIANT IS NOT SUPPORTED **
--Type without columns
--CREATE TYPE type1;
CREATE TABLE table1
(
column1 type1 /*** MSC-WARNING - MSCEWI1062 - CUSTOM TYPE 'type1' USAGE CHANGED TO VARIANT ***/
);
SELECT
column1 /*** MSC-ERROR - MSCEWI1065 - COLUMNS FROM EXPRESSION NOT FOUND ***/
FROM table1;

Recommendations

  • Verify that the type definition that was referenced does have columns within it.
  • If you need more support, you can email us at [email protected]