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-30333: dimension does not exist

1 Answers  


ORA-16640: CRS warns that multiple instances may still be running.

1 Answers  


ORA-30754: column or table string stores objects of only one type

1 Answers  


PLS-00729: only widening of the collection element type is allowed

1 Answers  


ORA-16082: logical standby is not initialized correctly

1 Answers  






ORA-31446: this session does not own the lock handle for string

1 Answers  


ORA-12424: length exceeds binary label size

1 Answers  


ORA-31434: purge is currently running

1 Answers  


ORA-02738: osnpwrtbrkmsg: incorrect number of bytes written

1 Answers  


QSM-01010: table(s) in the query not found in materialized view, string

1 Answers  


SQL*Loader-00279: Only APPEND mode allowed when parallel load specified.

1 Answers  


ORA-00027: cannot kill current session

1 Answers  


Categories