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


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

PLS-00319: subquery in an IN or NOT IN clause must contain exactly one column

1 Answers  


DRG-12509: length of the stop word string exceeded the limit of string bytes

1 Answers  


ORA-01222: MAXINSTANCES of string requires MAXLOGFILES be at least string, not string

1 Answers  


PCC-02334: SQL identifier was not declared as a cursor

1 Answers  


ORA-24752: OCI_TRANS_NEW flag must be specified for local transactions

1 Answers  






ORA-26512: error pushing transaction to def$error

1 Answers  


ORA-37134: (XSCCOMP09) You cannot add new values to workspace object because it includes positions for precomputed aggregate values.

1 Answers  


ORA-14408: partitioned index contains subpartitions in a different tablespace

1 Answers  


SQL-02122: Invalid OPEN or PREPARE for this database connection

1 Answers  


ORA-14606: Tablespace was specified for previous subpartitions in template but is not specified for string

1 Answers  


NZE-28797: invalid key data type

1 Answers  


PCC-02108: UNSAFE_NULL=YES allowed if MODE=ORACLE and DBMS=V7 or V8

1 Answers  






Categories