ora-12571 TNS:Packet writer failure(DV2000 r2.1 100分解决)
lthsj 2002-06-24 10:42:00 form 5.0.6.8.0 /win98 Oracle 8.04 for NT
使用EXEC_SQL包,向目标库中循环插入记录时,第一条成功,第二调出错。ora-12571 TNS:Packet writer failure
目标表结构和源结构一致:
DWBM NOT NULL VARCHAR2(5)
DWMC VARCHAR2(60)
DWJC VARCHAR2(20)
ZTBZ VARCHAR2(1)
JYFS VARCHAR2(1)
LXR VARCHAR2(12)
LXFS VARCHAR2(50)
FZR VARCHAR2(12)
FZLXFS VARCHAR2(50)
TZRQ VARCHAR2(8)
TZR VARCHAR2(12)
SHR VARCHAR2(12)
DWFR VARCHAR2(12)
DHHM VARCHAR2(30)
CZHM VARCHAR2(30)
YHZH VARCHAR2(20)
SWDM VARCHAR2(15)
KHYH VARCHAR2(40)
CSJJ VARCHAR2(100)
CSJJ1 VARCHAR2(100)
CSZL VARCHAR2(1)
JYPP VARCHAR2(100)
XSQD VARCHAR2(40)
SCFW VARCHAR2(40)
DWDZ VARCHAR2(100)
BZ VARCHAR2(500)