Comment on page

MSCEWI1064

Referenced custom type in query not found

Severity
High
Description
This error happens when a Custom Type is referenced in a source for a DML statement, but the Custom Type was never defined.
For example in a Table Column whose type might be a UDT but it was never defined.
Not to be confused with MSCEWI1055, which is when it was referenced in a DDL query.
Example Code
Input Code (Oracle):
--Type was never defined
--CREATE TYPE type1;
​
CREATE TABLE table1
(
--the type will be unresolved
column1 type1
);
​
SELECT
column1
FROM table1;
Output Code:
--Type was never defined
--CREATE TYPE type1;
​
CREATE TABLE table1
(
--the type will be unresolved
column1 type1 /*** MSC-WARNING - MSCEWI1055 - REFERENCED CUSTOM TYPE 'typeABC' NOT FOUND ***/
);
​
SELECT
column1 /*** MSC-ERROR - MSCEWI1064 - REFERENCED CUSTOM TYPE 'type1' IN QUERY NOT FOUND ***/
FROM table1;
Recommendations
Verify that the type that was referenced was defined in the input code.
If you need more support, you can email us at [email protected]​

MSCEWI1063

MSCEWI1065