CREATE OR REPLACE TYPE DEMO.CHILDORG_TY AS OBJECT
(
ORGANIZATION_ID NUMBER,
ORGANIZATION_NAME VARCHAR2(250),
PARENT_ORGANIZATION NUMBER,
ORGANIZATION_LEVEL NUMBER
);
CREATE OR REPLACE TYPE DEMO.CHILDORG_TY AS OBJECT ( ORGANIZATION_ID NUMBER, ORGANIZATION_NAME VARCHAR2(250), PARENT_ORGANIZATION NUMBER, ORGANIZATION_LEVEL NUMBER ); 以上SQL语句在Toad里执行成功,在我C#程序里作为OracleCommand的CommandText执行,结果创建了一个打了红叉的对象(Invalid),不知为什
CREATE OR REPLACE TYPE DEMO.CHILDORG_TY AS OBJECT(ORGANIZATION_ID NUMBER,ORGANIZATION_NAME VARCHAR2(250),PARENT_ORGANIZATION NUMBER,ORGANIZATION_LEVEL NUMBER)
[/Quote]
CREATE OR REPLACE TYPE DEMO.CHILDORG_TY AS OBJECT(ORGANIZATION_ID NUMBER,ORGANIZATION_NAME VARCHAR2(250),PARENT_ORGANIZATION NUMBER,ORGANIZATION_LEVEL NUMBER)