How to fix the Oracle error PLS-00505: User Defined Types may only be defined as PLSQL Tables or Records?

In this post, you’ll learn more about the Oracle ErrorPLS-00505: User Defined Types may only be defined as PLSQL Tables or Records with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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

How to fix the Error PLS-00505: User Defined Types may only be defined as PLSQL Tables or Records ?

You can fix this error in Oracle by following the below steps

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