Oracle Error PLS-00505: User Defined Types may only be defined as PLSQL Tables or Records

Oracle Error Message

PLS-00505: User Defined Types may only be defined as PLSQL Tables or Records

Reason for the Error

An attempt was made to define a type other than TABLE or RECORD, but these are the only user- defined types allowed in this release of PL/SQL. For example, the following type definition is illegal: TYPE Byte IS INTEGER(2); — illegal

Solution

Remove the type definition, or revise it to specify a TABLE or RECORD type.