字段长度的问题,求助!
各位好!小弟有个奇怪的问题请教:
我建了一个表:
Create Table Appaid_InvoicePrint(
IPNo varchar2(20) Constraint Nn_Appaid_InvoicePrint_IPNo not null,
AppNo varchar2(20) Constraint Nn_Appaid_InvoicePrint_AppNo not null,
RcptNo varchar2(20),
Fcu varchar2(20) Constraint Nn_Appaid_InvoicePrint_Fcu not null,
Fcd date Constraint Nn_Appaid_InvoicePrint_Fcd not null,
Constraint PK_Appaid_InvoicePrint_IPNo Primary Key(IPNo)
)
在ASP页面中构造了一个SQL:
Insert into Appaid_InvoicePrint (IPNo,AppNo,RcptNo,Fcu,Fcd) Values ('IP00000001','GA05000000018783',null,'admin',sysdate)
奇怪的是,在页面中执行SQL会报错:Inserted value is too large for the column,但是我把SQL直接在pl/sql中执行,又一切正常。请帮帮忙找找原因,谢谢!