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



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

Answer / guest

Cause: 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

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

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-14299: total number of partitions/subpartitions exceeds the limit of 65535

1 Answers  


TNS-12635: No authentication adapters available

1 Answers  


ORA-16531: unable to post message

1 Answers  


ORA-07403: sfanfy: db_writers parameter not valid.

1 Answers  


ORA-10575: Give up restoring recovered datafiles to consistent state: out of memory

1 Answers  






NNL-00268: Enter name server password:

1 Answers  


NNL-01068: Trace file name: string

1 Answers  


ORA-38449: table "string" does not exist or is not accessible

1 Answers  


ORA-28530: Heterogeneous Services initialization error in NLS language ID

1 Answers  


RMAN-06456: command is obsolete

1 Answers  


AMD-00157: invalid attach mode "string" specified when attempting to attach Workspace "string"

1 Answers  


ORA-01720: grant option does not exist for 'string.string'

1 Answers  


Categories