PLS-00505: User Defined Types may only be defined as PLSQL
Tables or Records
- 1 Answers
- 2967 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-19734: wrong creation SCN - control file expects converted plugged-in datafile
PCC-02435: This attribute is only valid for internal LOB types
ORA-27411: An empty string is not a valid repeat interval.
RMAN-06425: <datafile pathname not available>
ORA-02833: Server was unable to close file
RMAN-08549: database name (or lock name space) used for search: string
ORA-02245: invalid ROLLBACK SEGMENT name
ORA-09752: pw_attachPorts: port_allocate failed.
RMAN-05511: Datafile string skipped by request
ORA-15026: disk 'string' is not an ASM disk
TNS-03505: Failed to resolve name
NNL-00540: [show] status [<server_list>] : display server status summary
Oracle Errors 
