aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

PLS-00315: Implementation restriction: unsupported table index type

PLS-00315: Implementation restriction: unsupported table index type
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.

请先 登录 后评论

1 个回答

小智
PLS-00315:实施限制:不支持的表索引类型,
.原因:在PL / SQL表声明的INDEX BY子句中,指定了除BINARY_INTEGER,PLS_INTEGER或VARCHAR2之外的数据类型。PL / SQL表可以有一列和一个主键。该列可以具有任何标量类型,但主键必须是二进制整数类型或VARCHAR2。,
.操作:在INDEX BY子句中使用支持的键类型之一。,
.
请先 登录 后评论