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-24386: statement/server handle is in use when being freed

1 Answers  


ORA-15000: command disallowed by current instance type

1 Answers  


ORA-02854: Invalid number of request buffers

1 Answers  


TNS-01414: "string", state string, established string, refused string, current string, max string

1 Answers  


ORA-16576: failed to update Data Guard configuration file

1 Answers  






QSM-01031: materialized view, string, is stale in TRUSTED integrity mode

1 Answers  


ORA-09788: sllfrb: unable to read file.

1 Answers  


ORA-01320: Invalid Logminer dictionar attribute

1 Answers  


NNO-00627: cancelling auto-refresh of name "string", type "string"

1 Answers  


RMAN-12010: automatic channel allocation initialization failed

1 Answers  


ORA-16808: unable to resolve the full path name

1 Answers  


ORA-00330: archived log ends at change string, need change string

1 Answers  


Categories