PLS-00505: User Defined Types may only be defined as PLSQL
Tables or Records
- 1 Answers
- 3149 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 |
IMP-00401: dump file "string" may be an Data Pump export dump file
EXP-00036: Object number non-existent in dictionary
ORA-07718: sksafre: error freeing memory
IMG-00002: unrecoverable error
NNL-01066: Statistic counter logging interval: string
ORA-24385: Application context size or index is not valid
ORA-01945: DEFAULT ROLE[S] already specified
ORA-01284: file string cannot be opened
ORA-14315: cannot merge a partition with itself
ORA-13906: The tablepace is not of the right type.
ORA-09958: IMON: two processes with the same ORACLE pid are active
O2F-00328: Illegal INITFUNC name
Oracle Errors 
