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

PLS-00707: unsupported construct or internal error [string]

1 Answers  


ORA-07564: sldext: wildcard in filename or extension

1 Answers  


ORA-23446: duplicate template site

1 Answers  


ORA-16004: backup database requires recovery

1 Answers  


DRG-11224: Third-party filter is unable to create or write to temporary file.

1 Answers  






ORA-12823: default degree of parallelism may not be specified here

1 Answers  


ORA-07498: spstp: Unable to open /dev/resched.

1 Answers  


DRG-12439: highlight table read failed

1 Answers  


ORA-07563: sldext: $PARSE failure

1 Answers  


DRG-10314: logging has not been started

1 Answers  


PLS-00554: character set has already been determined

1 Answers  


QSM-01062: query has one or more manual partition(s)

1 Answers  


Categories