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-12448: policy string not applied to schema string

1 Answers  


PCC-01100: You are not authorized to run Pro*FORTRAN

1 Answers  


DRG-11863: Bad, Incomplete, Or Unknown Response

1 Answers  


ORA-02762: file number to be cancelled is greater than the maximum.

1 Answers  


ORA-30002: SYS_CONNECT_BY_PATH function is not allowed here

1 Answers  


NNF-04001: Error converting input file

1 Answers  


DRG-11215: index owner does not have access to filter stored procedure: string

1 Answers  


PLS-00380: functions and procedures are not included in this release of PL/SQL

1 Answers  


ORA-02424: potential circular view references or unknown referenced tables

1 Answers  


ORA-02854: Invalid number of request buffers

1 Answers  


NNL-00508: show system_queries [<server_list>] : show system query information

1 Answers  


ORA-32306: updatable materialized views with user-defined types must use SELECT *

1 Answers  


Categories