PLS-00315: Implementation restriction: unsupported table
index type



PLS-00315: Implementation restriction: unsupported table index type..

Answer / guest

Cause: In the INDEX BY clause of a PL/SQL table declaration,
a datatype other than BINARY_INTEGER, PLS_INTEGER, or
VARCHAR2 was specified. PL/SQL tables can have one column
and a primary key. The column can have any scalar type, but
the primary key must be either a binary integer type or
VARCHAR2.

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-22990: LOB locators cannot span transactions

1 Answers  


DRG-50912: first document number string is not an integer

1 Answers  


RMAN-06050: archive log thread number sequence number is already on disk as file string

1 Answers  


DRG-11427: valid gist level values are string

1 Answers  


ORA-03113: end-of-file on communication channel

1 Answers  


ORA-30456: 'string.string' cannot be refreshed because of insufficient privilege

1 Answers  


O2I-00129: No Java file specified

1 Answers  


TNS-01183: Listener rejected registration or update of instance "string"

1 Answers  


ORA-27470: failed to re-enable "string.string" after making requested change

1 Answers  


QSM-02045: START WITH clause in mv

1 Answers  


TNS-04071: Connections closed successfully. Number closed: number.

1 Answers  


ORA-01143: cannot disable media recovery - file string needs media recovery

1 Answers  


Categories