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

RMAN-06564: must use the TO clause when the instance is started with SPFILE

1 Answers  


KUP-04004: error while reading file string

1 Answers  


DRG-11835: Requested Range Not Satisfiable

1 Answers  


ORA-15176: file 'string' already has an alias associated with it

1 Answers  


LPX-00230: invalid character ~1u (~2x) found in a Name or Nmtoken

1 Answers  






PCB-00229: Indicator variable "string" has wrong type or length

1 Answers  


ORA-13033: Invalid data in the SDO_ELEM_INFO_ARRAY in SDO_GEOMETRY object

1 Answers  


ORA-01626: rollback segment number 'string' cannot handle more transactions

1 Answers  


QSM-02134: agg(expr) requires correspondng MAX(expr) function

1 Answers  


ORA-28593: agent control utility: command terminated with error

1 Answers  


ORA-09878: sstascre/sstasat: shmat error, unable to attach tas write page

1 Answers  


ORA-00215: must be at least one controlfile

1 Answers  


Categories