Interested to Buy Any Domain ? << Click Here >> for more details...
PLS-00505: User Defined Types may only be defined as PLSQL
Tables or Records
- 1 Answers
- 3671 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-30347: a table name is required to qualify the column specification
ORA-22817: subquery not allowed in the default clause
RMAN-06024: no backup or copy of the controlfile found to restore
ORA-39140: dump file "string" belongs to job string
ORA-31477: could not detach LogMiner session during cleanup
ORA-02263: need to specify the datatype for this column
ORA-16555: The Data Guard database is not active.
ORA-01032: no such userid
KUP-04053: record number number
RMAN-20241: ambiguous archived log name
ORA-22954: This multiset operation is not supported for this element type.
ORA-14134: indexes cannot use both DESC and REVERSE
Oracle Errors 
