自定义类型插入数据时报错[Err] ORA-00932: 数据类型不一致: 应为 UDT, 但却获得 CHAR
我自定义类型如下:
CREATE OR REPLACE TYPE OperateChargeBill_ty AS OBJECT (
AGENTNAME VARCHAR2(250),
BILLNO VARCHAR2(32),
GNPH NUMBER,
GNTSHW NUMBER,
GNGZHP NUMBER,
GNWXWP NUMBER,
GNTD NUMBER,
GNTDN NUMBER,
GJPH NUMBER,
GJTSHW NUMBER,
GJGZHP NUMBER,
GJWXWP NUMBER,
GJTDN NUMBER,
GJTD NUMBER,
RETURNREMARK VARCHAR2(100)
)
create or replace type OperateChargeBill_tb is table of OperateChargeBill_ty;
插入数据时用的sql语句如下:
SELECT * FROM TABLE(OperateChargeBill_tb('shunfeng','111-11111111',80,0,0,0,0,0,0,0,0,0,0,0,'wu'))
我明明定义的是vchar类型的数据为什么会报错是UDT