¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮
ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
Caused by: java.sql.BatchUpdateException: ORA-01461: can bind a LONG value only for insert into a LONG column
Èç¹û³¤¶È¸Ä³É500¾ÍûÎÊÌ⣮
ÈçºÎ½â¾öÕâ¸öÎÊÌ⣿Çë¸ø¸ö¼ò±ãµÄ·½·¨£¬ÒѾÕâÊÇÒѾÉÏÏßµÄϵͳ£¬²»ÊʺÏÔÙ×ö´óµÄ¸Ä¶¯£®
oracleµÄ³¤¶È´óСÊDz»ÊǼ¸£ËµÄÏÞÖÆ°¡£¬¿É²»¿ÉÒÔͨ¹ýµ÷oracle²ÎÊýÀ´Ð޸ģ®
½ô¼±ÇóÖú£¬¸Ðл´ó¼Ò£®
ÒýÓà ¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮ ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update Caused by: java.sql.BatchUpdateException: ORA-01461: can bind a LONG value only for insert into a LONG column Èç¹û³¤¶È¸Ä³É500¾ÍûÎÊÌ⣮ ÈçºÎ½â¾öÕâ¸öÎÊÌ⣿Çë¸ø¸ö¼ò±ãµÄ·½·¨£¬ÒѾÕâÊÇÒѾÉÏÏßµÄϵͳ£¬²»ÊʺÏÔÙ×ö´óµÄ¸Ä¶¯£® oracleµÄ³¤¶È´óСÊDz»ÊǼ¸£ËµÄÏÞÖÆ°¡£¬¿É²»¿ÉÒÔͨ¹ýµ÷oracle²ÎÊýÀ´Ð޸ģ® ½ô¼±ÇóÖú£¬¸Ðл´ó¼Ò£®"Èç¹û³¤¶È¸Ä³É500¾ÍûÎÊÌâ",ÊÇÖ¸²åÈëÊý¾ÝµÄ³¤¶È»¹ÊÇvarchar2µÄ³¤¶È£¿
²åÈëÊý¾ÝµÄ³¤¶ÈΪ500.varchar2µÄ³¤¶È»¹ÊÇ3000
²åÈëÊý¾ÝµÄÊDz»ÊÇÓзÇasciiµÄ×Ö·û£¿
ÊÔһϰÑvarchar2¸Ä³Ænvarchar2ÊÔÒ»ÏÂ
»òÕ߸ÄÓÃvarchar2(3000 char)
ÒýÓà ¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮
Ïà¹ØÎÊ´ð£º
delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×ֶΠhttp://blog.csdn.net/zxf_feng/archive/2008/12/21/3571961.aspx ¿´¿´Õâ¸ö ÒýÓà vStream := TMemorySt ......
with adod_dict do begin close; commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ֪µÀÔõôŪÁË µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿ ¸½Í¼Æ¬ ......
Êý¾Ý±Ãµ¼È뱨ÈçÏ´íÎóORA-39016 ²»ÖªµÀÊÇʲôÔÒò,ÇëÖ¸½Ì.... лл' Processing object type TABLE_EXPORT/TABLE/TABLE_DATA ORA-39016: Operation not supported when job is in EXECUTING ......