PLS-00507: a PLSQL Table may not contain a table or a record
with composite fields

Answers were Sorted based on User's Feedback



PLS-00507: a PLSQL Table may not contain a table or a record with composite fields..

Answer / guest

Works with 9i onwards.

Is This Answer Correct ?    1 Yes 0 No

PLS-00507: a PLSQL Table may not contain a table or a record with composite fields..

Answer / guest

Cause: In a TABLE type definition, a nested record type was
specified as the element type. This is not allowed. All
fields in the record must be scalars.

Action: Remove the TABLE type definition, or replace the
nested record type with a simple record type.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-12483: label not in OS system accreditation range

1 Answers  


RMAN-06048: duplicate controlfile specified for restoration from copy

1 Answers  


PLS-01455: The predicates IS NULL and IS NOT NULL are defined only for column specifications

1 Answers  


TNS-02512: Invalid status received

1 Answers  


DRG-50928: reserved failure on line string on column string

1 Answers  






SQL-02136: Invalid NCHAR character set id

1 Answers  


NNL-00414: Maximum response time: string

1 Answers  


ORA-29959: error in the execution of the string routine for one or more of the index partitions

1 Answers  


ORA-30198: reserved for future use

1 Answers  


PLS-00580: supertype must be an object type

1 Answers  


RMAN-08016: channel string: starting datafile backupset restore

1 Answers  


PCC-00092: Length and/or scale incompatible with specified Oracle datatype

1 Answers  


Categories