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.
解决方案 »
- oracle触发器问题:hz_parties发生了变化 触发器/函数不能读取。
- 谁能给我讲讲这四个视图关于job的视图?谢谢
- 请问怎样实现用MSSQL的导出数据把MSSQL库里的数据导入LINUX平台下的ORACLE9I里?
- oracal 如何存多张图片
- 如何通过存储过程计算一条SQL语句执行时间?
- 各位高手进来看看,VB访问Oracle数据库的问题。解决问题再送分。
- oracle92中是否有pro*c工具
- 急!请问如何从DMP 中恢复数据库?(我不知该数据库内容和用户)
- 介绍一些oracle的pl/sql的经典书籍
- 请各位高手帮忙
- 向高手请教: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,