为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:麒麟V7
【CPU】:x86
【问题描述】*:
通过应用查询包含有大字段(TXT) 的语句报这个 dm.jdbc.driver.DmdbNClob@27edd98c 错误,数据库查询正常有字符串截断的问题,这个应用报错是因为什么
建表语句:
CREATE TABLE “SY_WFE_PROC_DEF”
(
“PROC_CODE” VARCHAR2(80) NOT NULL,
“PROC_NAME” VARCHAR2(160),
“PROC_TYPE” NVARCHAR(160),
“SERV_ID” VARCHAR2(80),
“PROC_MEMO” VARCHAR2(400),
“S_PUBLIC” NUMBER(4,0),
“S_FLAG” NUMBER(4,0),
“S_CMPY” VARCHAR2(80),
“S_USER” VARCHAR2(80),
“EN_NAME” VARCHAR2(80),
“PROC_XML” TEXT,
“BIND_TITLE” VARCHAR2(800),
“BIND_BUTTONS” VARCHAR2(800),
“BIND_BUTTONS_NAME” VARCHAR2(800),
“BIND_ENDEDITFIELD” VARCHAR2(800),
“PROC_MANAGE” VARCHAR2(80),
“SERV_PID” VARCHAR2(80),
“EXPAND_CLASS” VARCHAR2(400),
“PROC_MANAGE_EDIT” VARCHAR2(800),
“S_MTIME” VARCHAR2(46),
“BIND_SCRIPT” VARCHAR2(8000),
“BIND_SORT” NUMBER(4,0),
“PROC_CATALOG” VARCHAR2(80),
“PROC_VERSION” NUMBER(4,0),
“EFFECTIVE_DATE” VARCHAR2(46),
“PROC_IS_LATEST” NUMBER(4,0),
“FINISH_REMIND” VARCHAR2(800),
“RTN_QCR_FLAG” NUMBER(4,0),
“CUSTOM_SEND_CONFIG” VARCHAR2(8000),
“BELONG_ODEPT” VARCHAR2(80)),
CONSTRAINT “PK_SY_WFE_PROC_DEF” NOT CLUSTER PRIMARY KEY(“PROC_CODE”)) STORAGE(ON “GSTZOA”, CLUSTERBTR) ;
SQL查询如下:
select
PROC_CODE ,
EN_NAME ,
PROC_NAME ,
SERV_ID ,
BIND_TITLE ,
S_PUBLIC ,
PROC_MANAGE ,
EXPAND_CLASS ,
PROC_MANAGE_EDIT ,
PROC_TYPE ,
BIND_BUTTONS_NAME,
PROC_CATALOG ,
BELONG_ODEPT ,
BIND_SCRIPT ,
BIND_ENDEDITFIELD,
BIND_SORT ,
PROC_MEMO ,
S_FLAG ,
PROC_VERSION ,
EFFECTIVE_DATE ,
PROC_IS_LATEST ,
FINISH_REMIND ,
SERV_PID ,
BIND_BUTTONS ,
S_CMPY ,
S_USER ,
S_MTIME ,
PROC_XML
from
SY_WFE_PROC_DEF
where
1 =1
and PROC_CODE=‘gsfw_gsyt@2@6’
程序里面是怎么写的查询尼