SR版本：3.2.9；
Oracle版本：11.2
表DDL:
CREATE TABLE “TABLE_NAME”
( “SGBH” VARCHAR2(16) NOT NULL ENABLE,
“XZQH” VARCHAR2(10) NOT NULL ENABLE,
“DJBH” VARCHAR2(15) NOT NULL ENABLE,
“KSKCSJ” DATE,
“JSKCSJ” DATE,
“XQ” NUMBER(1,0),
“SGFSSJ” DATE,
“LH” VARCHAR2(7) DEFAULT ‘-’,
“LM” VARCHAR2(64),
“GLS” NUMBER(5,0),
“MS” NUMBER(4,0),
“QDMS” NUMBER(4,0),
“JDWZ” NUMBER(8,0) DEFAULT 0,
“SGDD” VARCHAR2(128),
“ZHDMWZ” CHAR(1),
“ZYGLSS” VARCHAR2(1),
“DLAQSX” VARCHAR2(1),
“JTXHFS” VARCHAR2(5),
“FHSSLX” VARCHAR2(2),
“DLWLGL” CHAR(1),
“LMZK” CHAR(1),
“LBQK” VARCHAR2(2),
“LMJG” CHAR(1),
“LKLDLX” CHAR(2),
“DLXX” VARCHAR2(2),
“DLLX” CHAR(2),
“KCR1” VARCHAR2(30),
“KCR2” VARCHAR2(30),
“BAR1” VARCHAR2(30),
“BAR2” VARCHAR2(30),
“SWRS” NUMBER(3,0) DEFAULT 0,
“SWRSQ” NUMBER(3,0) DEFAULT 0,
“SWRS24” NUMBER(3,0) DEFAULT 0,
“SSRS24” NUMBER(3,0) DEFAULT 0,
“SWRS3” NUMBER(3,0) DEFAULT 0,
“SSRS3” NUMBER(3,0) DEFAULT 0,
“SWRS7” NUMBER(3,0) DEFAULT 0,
“SSRS7” NUMBER(3,0) DEFAULT 0,
“SWRS30” NUMBER(3,0) DEFAULT 0,
“SSRS30” NUMBER(3,0) DEFAULT 0,
“SZRS” NUMBER(3,0) DEFAULT 0,
“ZSRS” NUMBER(3,0) DEFAULT 0,
“QSRS” NUMBER(3,0) DEFAULT 0,
“SSRS” NUMBER(3,0) DEFAULT 0,
“JDCSL” NUMBER(3,0) DEFAULT 0,
“FJDCSL” NUMBER(3,0) DEFAULT 0,
“XRSL” NUMBER(3,0) DEFAULT 0,
“XSGLBM” VARCHAR2(12),
“XSBADW” VARCHAR2(64),
“XSBAR” VARCHAR2(32),
“TPZS” NUMBER(3,0) DEFAULT 0,
“XCTZS” NUMBER(3,0) DEFAULT 0,
“XCZPZS” NUMBER(3,0) DEFAULT 0,
“ZJCCSS” NUMBER(9,0) DEFAULT 0,
“SGLX” CHAR(1),
“LWSGLX” CHAR(1),
“CCYYFL” VARCHAR2(2),
“RDYYFL” VARCHAR2(2),
“SGCCYY” VARCHAR2(4),
“SGRDYY” VARCHAR2(4),
“JYAQ” VARCHAR2(2000),
“TQ” VARCHAR2(2),
“NJD” CHAR(1),
“XC” CHAR(1),
“SWSG” CHAR(1),
“SGXT” CHAR(2),
“SFTY” CHAR(1),
“CLJSG” VARCHAR2(1),
“DCSG” VARCHAR2(2),
“PZFS” VARCHAR2(1),
“TYSGZP” CHAR(1),
“TYZPSJ” DATE,
“DX” CHAR(1),
“ZMTJ” CHAR(1),
“TJR1” VARCHAR2(30),
“TJR2” VARCHAR2(30),
“YZWXP” CHAR(1),
“YZWXPHG” VARCHAR2(2),
“CCLRSJ” DATE,
“JLLX” CHAR(1),
“SCSJD” NUMBER,
“JBR” VARCHAR2(30),
“TJSJ” DATE,
“GXSJ” DATE,
“SSZD” VARCHAR2(12),
“GLXZDJ” CHAR(1),
“DAH” VARCHAR2(50),
“JNH” NUMBER(3,0),
“SXXZ” VARCHAR2(10),
“SB” CHAR(1),
“TJSGBH” VARCHAR2(64),
“GLBM” VARCHAR2(12),
“YLZD1” VARCHAR2(100),
“YLZD2” VARCHAR2(100),
“YLZD3” VARCHAR2(100),
“YLZD4” VARCHAR2(100),
“YLZD5” VARCHAR2(100),
“DZZB” VARCHAR2(1024),
“TDYL1” VARCHAR2(100),
“TDYL2” VARCHAR2(100),
“TDYL3” VARCHAR2(100),
“TDYL4” VARCHAR2(100),
“TDYL5” VARCHAR2(100),
“TDYL6” VARCHAR2(100),
“TDYL7” VARCHAR2(100),
“TDYL8” VARCHAR2(100),
“TDYL9” VARCHAR2(100),
“TDYL10” VARCHAR2(100),
“BALXFS” VARCHAR2(100),
“BADW” VARCHAR2(100),
“XYXDM” VARCHAR2(12),
“JYW” VARCHAR2(64),
“SFECSG” CHAR(1),
“SFDXSG” CHAR(1) DEFAULT ‘2’,
“DLAQYHDJ” VARCHAR2(1),
“DSRZS” NUMBER(3,0) DEFAULT 0,
“FSJG” VARCHAR2(10),
“FFJG” VARCHAR2(128),
“SDSGDSCWZ” VARCHAR2(1),
“HLZT” VARCHAR2(2),
CONSTRAINT “PK_ACD_FILE” PRIMARY KEY (“SGBH”)
) ;
CREATE UNIQUE INDEX “PK_ACD_FILE” ON “TABLE_NAME” (“SGBH”) ;
CREATE UNIQUE INDEX “IDX_ACD_FILE_DJBH” ON “TABLE_NAME” (“DJBH”) ;
CREATE INDEX “IDX_ACD_FILE_GLBM” ON “TABLE_NAME” (“GLBM”) ;
CREATE INDEX “IDX_ACD_FILE_TJSGBH” ON “TABLE_NAME” (“TJSGBH”) ;
CREATE INDEX “IDX_SGFSSJ” ON “TABLE_NAME” (“SGFSSJ”) ;
查询报错语句：
1 select SGBH from catalogname.schemaname.TABLE_NAME;
报错日志：“ERROR 1064 (HY000): DECIMAL’s precision should range from 1 to 38”