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
- 3594 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 |
DRG-52204: error while registering index
RMAN-10015: error compiling PL/SQL program
TNS-01154: SID detected in old format that is no longer supported
RMAN-06162: sql statement: string
RMAN-08018: channel string: starting archive log restore to user-specified destination
ORA-22340: cannot string type "string"."string". Dependent tables must be upgraded to latest version
ORA-24029: operation not allowed on a single-consumer queue
LPX-00106: attribute "~1S" of element "~2S" is undefined
TNS-00264: Navigator: Failed to reload configuration data
TNS-00257: Number of Successful Requests : number
TNS-01112: Plug and play can either be ON or OFF
ORA-14192: cannot modify physical index attributes of a Hash index partition
Oracle Errors 
