Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


PLS-00505: User Defined Types may only be defined as PLSQL
Tables or Records



PLS-00505: User Defined Types may only be defined as PLSQL Tables or Records..

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

Post New Answer

More Oracle Errors Interview Questions

ORA-22920: row containing the LOB value is not locked

1 Answers  


ORA-27077: too many files open

1 Answers  


ORA-39031: invalid filter name string

1 Answers  


NZE-28869: Peer's certificate is expired.

1 Answers  


NCR-04018: NCRR: Unable to create the TNS address list

1 Answers  






LSX-00272: BASE64-encoded binary grouped improperly (not 4's)

1 Answers  


ORA-25131: cannot modify unique(string) - unique key not defined for table

1 Answers  


LSX-00105: duplicate attribute group "~S"

1 Answers  


ORA-19578: end of volume while duplexing to sequential files, backup piece incomplete

1 Answers  


ORA-26505: unexpected internal null

1 Answers  


DRG-13006: sub lexer for this language is not defined

1 Answers  


SQL*Loader-00709: Internal error calling SLTS layer: string failed

1 Answers  


Categories