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.
