表中没有任何long类型数据,而且没有数据超出字段的长度,但为什么报这个错误呢
update aiccusercourseau set j_status = ?,j_score = ?
where tl_id = ? and us_id = ?
and (j_status is null or j_status not in ('Complete', 'c', 'Pass', 'pass', 'p', 'Passed', 'Completed', 'completed'))
and au_id in (select au_id from AiccAUInfo where cid = ? and developer_id = ?)
param:[, -1, 10436, 319971, 10482, HRA101002003000X820001]
ERROR [ExecuteThread: '293' for queue: 'default'] - ORA-01461: can bind a LONG value only for insert into a LONG column
SQL> desc aiccusercourseau
名称 是否为空? 类型
----------------------------------------- -------- ----------------------
UA_ID NOT NULL NUMBER(20)
TL_ID NOT NULL NUMBER(20)
AU_ID NOT NULL NUMBER(20)
US_ID NOT NULL NUMBER(20)
J_STATUS VARCHAR2(50)
J_SCORE NUMBER(20,2)
SQL> desc AiccAUInfo
名称 是否为空? 类型
----------------------------------------- -------- ---------------
AU_ID NOT NULL NUMBER(20)
AUCODE NOT NULL VARCHAR2(50)
CID NOT NULL NUMBER(20)
DEVELOPER_ID NOT NULL VARCHAR2(50)
TYPE NOT NULL NUMBER(1)
AUURL VARCHAR2(200)
TITLE VARCHAR2(100)
DESCRIPTION VARCHAR2(4000)
MAX_SCORE NUMBER(8,2)
MASTERY_SCORE NUMBER(8,2)
SYSTEM_VENDOR VARCHAR2(255)
CORE_VENDOR VARCHAR2(255)
WEB_LAUNCH VARCHAR2(255)
SQL> select * from v$version
2 ;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
PL/SQL Release 9.2.0.4.0 - Production
CORE 9.2.0.3.0 Production
TNS for HPUX: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production
SQL> select * from v$nls_parameters;
PARAMETER VALUE
------------------------------ ------------------------------
NLS_LANGUAGE SIMPLIFIED CHINESE
NLS_TERRITORY CHINA
NLS_CURRENCY ¥
NLS_ISO_CURRENCY CHINA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE SIMPLIFIED CHINESE
NLS_CHARACTERSET ZHS16GBK
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
PARAMETER VALUE
------------------------------ ------------------------------
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY ¥
NLS_NCHAR_CHARACTERSET UTF8
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
已选择19行。