PLS-00505: User Defined Types may only be defined as PLSQL Tables or Records

PLS-00505: User Defined Types may only be defined as PLSQL Tables or Records
Cause: An attempt was made to define a type other than TABLE or RECORD, but these are the only user- defined types allowed in this release of PL/SQL. For example, the following type definition is illegal: TYPE Byte IS INTEGER(2); -- illegal
Action: Remove the type definition, or revise it to specify a TABLE or RECORD type.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00505：用户定义的类型只能定义为PLSQL表或记录,
.原因：尝试定义除TABLE或RECORD之外的类型，但这些是此版本的PL / SQL中允许的唯一用户定义的类型。例如，以下类型定义是非法的：TYPE Byte IS INTEGER（2）; - 非法,
.操作：删除类型定义，或修改它以指定TABLE或RECORD类型。,
.

aiaiDBA

13718043309

010-86462881

PLS-00505: User Defined Types may only be defined as PLSQL Tables or Records

1 个回答

相似问题