ORGANNUM CHAR(2) not null,
ROLLID NUMBER (10,0) not null,
PIECENUM NUMBER (10,0) not null,
BUSINESSID NUMBER (10,0) not null,
PAGEFROM NUMBER (10,0) default '0' not null,
PAGETO NUMBER (10,0) default '0' not null,
PIECESTATUS VARCHAR2(6) not null,
?
ROLLID NUMBER (10,0) not null,
PIECENUM NUMBER (10,0) not null,
BUSINESSID NUMBER (10,0) not null,
PAGEFROM NUMBER (10,0) default '0' not null,
PAGETO NUMBER (10,0) default '0' not null,
PIECESTATUS VARCHAR2(6) not null,
?
ROLLID NUMBER not null,
PIECENUM NUMBER not null,
BUSINESSID NUMBER not null,
PAGEFROM NUMBER default '0' not null,
PAGETO NUMBER default '0' not null,
PIECESTATUS VARCHAR2(6) not null,是表IC_Roll_Information中各个字段的定义。
长度加大点试试。是不是'\0'的问题。
ROLLID NUMBER not null,
PIECENUM NUMBER not null,
BUSINESSID NUMBER not null,
PAGEFROM NUMBER default '0' not null,
PAGETO NUMBER default '0' not null,
PIECESTATUS VARCHAR2(6) not null,
Organ table.ORGANNUM%type;
改为 VARCHAR(2)