PLS-00505: User Defined Types may only be defined as PLSQL
Tables or Records
- 1 Answers
- 2762 Views
- I also Faced
- E-Mail Answers
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 |
ORA-15065: hash collision for diskgroup names 'string' and 'string'
ORA-14112: RECOVERABLE/UNRECOVERABLE may not be specified for a partition or subpartition
ORA-19568: a device is already allocated to this session
ORA-13374: SDO_MBR not supported for geodetic data
ORA-24763: transaction operation cannot be completed now
PCC-02361: Use of ARRAYLEN with SQL bind arrays is ignored
ORA-33332: (DSSEXIST01) Use the AW command to establish a current analytic workspace. Then start your current activity again.
LSX-00331: missing comma
ORA-19565: BACKUP_TAPE_IO_SLAVES not enabled when duplexing to sequential devices
ORA-36644: (XSDUNION07) Concat dimension workspace object contains a previously detected leaf dimension.
ORA-32737: Hang analysis aborted due to failed memory allocation
ORA-23447: missing user parameter value
Oracle Errors 
