PLS-00316: PL/SQL TABLEs must use a single index



PLS-00316: PL/SQL TABLEs must use a single index..

Answer / guest

Cause: In the INDEX BY clause of a PL/SQL table declaration,
a composite primary key was specified. PL/SQL tables must
have a simple, unnamed primary key of a binary integer or
VARCHAR2 type.

Action: Use one of the supported key types in the INDEX BY
clause.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-24377: invalid OCI function code

1 Answers  


RMAN-06498: skipping datafile string; already backed up string time(s)

1 Answers  


NNL-00418: Attributes Mapped: number

1 Answers  


ORA-01327: failed to exclusively lock system dictionary as required by build

1 Answers  


PLS-01451: The data types of these <value expressions> must be comparable

1 Answers  






TNS-01003: status [<listener_name>] : get the status of listener

1 Answers  


TNS-12212: TNS:incomplete PREFERRED_CMANAGERS binding in TNSNAV.ORA

1 Answers  


IMP-00091: Above error occurred on the following function and object: string. Remaining PL/SQL blocks for this object will be skipped.

1 Answers  


ORA-01415: too many distinct aggregate functions

1 Answers  


ORA-01947: TEMPORARY TABLESPACE already specified

1 Answers  


ORA-14185: incorrect physical attribute specified for this index partition

1 Answers  


NZE-28752: data source initialization failure

1 Answers  


Categories