CREATE TYPE address_typ AS OBJECT (
street VARCHAR2(15),
city VARCHAR2(15),
state CHAR(2),
zip VARCHAR2(5),
phone_numbers varray_phone_typ
);
/嵌套表是不是不支持 phone_numbers varray_phone_typ?
我觉得变长数组属于UROWID for a user-defined object type
datatype Restrictions: You cannot specify attributes of type ROWID, LONG, or LONG ROW. You cannot create an object with NCLOB, NCHAR, or NVARCHAR2 attributes, but you can specify parameters of these datatypes in methods. You cannot specify a datatype of UROWID for a user-defined object type. If you specify an object of type REF, the target object must have an object identifier.
street VARCHAR2(15),
city VARCHAR2(15),
state CHAR(2),
zip VARCHAR2(5),
phone_numbers varray_phone_typ
);
/嵌套表是不是不支持 phone_numbers varray_phone_typ?
我觉得变长数组属于UROWID for a user-defined object type
datatype Restrictions: You cannot specify attributes of type ROWID, LONG, or LONG ROW. You cannot create an object with NCLOB, NCHAR, or NVARCHAR2 attributes, but you can specify parameters of these datatypes in methods. You cannot specify a datatype of UROWID for a user-defined object type. If you specify an object of type REF, the target object must have an object identifier.
解决方案 »
- pl/sql developer7.1的两种存储过程有何区别?
- java.sql.SQLException: ORA-00604: 递归 SQL 级别 1 出现错误 ORA-01003: 语句未进行语法分析
- 一打开cmd就弹出"imp.exe遇到一个问题,需要关闭"
- c# 调用过程,报 {"ORA-01036: 非法的变量名/编号\n"} ,请帮忙
- 关于group by的sql语句?
- 十万火急!项目急用!请问下用存储过程如何将一个库中表的数据导入到另一个库中的表中?????
- 公交汽车站这个数据库应该怎么设计?
- 怎样实现这样的查询?
- 求救,我要恢复我的环境,最后一搏了,装winxp+oracle8i(8.1.6)的朋友进来看看!
- 我的硬盘装的windows2000,里面有oracle,怎样讲此硬盘放到别的电脑上,因为硬件不相同?
- 向高手请教:oracle的连接数以及如何判断连接数的原理
- 几种数据库地对比
street VARCHAR2(15),
city VARCHAR2(15),
state CHAR(2),
zip VARCHAR2(5),
phone_numbers varray_phone_typ
);
/嵌套表是不是不支持 phone_numbers varray_phone_typ?
我觉得变长数组属于UROWID for a user-defined object type
datatype Restrictions: You cannot specify attributes of type ROWID, LONG, or LONG ROW. You cannot create an object with NCLOB, NCHAR, or NVARCHAR2 attributes, but you can specify parameters of these datatypes in methods. You cannot specify a datatype of UROWID for a user-defined object type. If you specify an object of type REF, the target object must have an object identifier.
但是又有一错误,帮忙分析一下:
-------------------------------------------------
CREATE TYPE nested_table_rowbeginindex AS TABLE OF CHAR(30);
/CREATE TYPE rowindex_type AS OBJECT (
beginIndex nested_table_rowbeginindex,
tableName CHAR(30),
columnName CHAR(30),
columnValue CHAR(30)
);
/CREATE TYPE nested_table_rowindex AS TABLE OF rowindex_type;
/CREATE TABLE page (
pageName CHAR(30),
type NUMBER,
tableName CHAR(30),
tabletitle CHAR(80),
rowindex nested_table_rowindex
)
NESTED TABLE
rowindex
STORE AS
nested_rowindex;CREATE TABLE page (
*
ERROR 位于第 1 行:
ORA-02320: 无法创建嵌套表列ROWINDEX的存储表
ORA-22913: 必须指定嵌套表列或属性的表名称
beginIndex nested_table_rowbeginindex,