Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¼±ÎÊÒ»¸öoracle×Ö¶ÎÉèÖõÄÎÊÌâ - 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²ÎÊýÀ´Ð޸ģ®

½ô¼±ÇóÖú£¬¸Ðл´ó¼Ò£®
ÒýÓÃ
¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮

ÎÒÉèÖÃÁËÒ»¸ö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×Ö¶Î

delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î

http://blog.csdn.net/zxf_feng/archive/2008/12/21/3571961.aspx
¿´¿´Õâ¸ö

ÒýÓÃ
            vStream := TMemorySt ......

ORACLEÊý¾Ý¿âÖÐµÄ group by Óï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

ÖªµÀÔõô°Ñsasµ¼ÈëoracleµÄ½øÀ´¿´¿´

ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ­ÖªµÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......

¹òÇó lomboz eclipse ÖмÓÈëoracleµÄÎÊÌâ

ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
¸½Í¼Æ¬ ......

oracle impdpÎÊÌâ

Êý¾Ý±Ãµ¼È뱨ÈçÏ´íÎóORA-39016 ²»ÖªµÀÊÇʲôԭÒò,ÇëÖ¸½Ì....  лл'


Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-39016: Operation not supported when job is in EXECUTING ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ