oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í£Ö¹¡±×´Ì¬£¬Æô¶¯²»ÁË£¬Ò²¹Ø±Õ²»ÁË¡£
ÔÚÏߵȸßÊֻشð!ллÏÈ£¡
´íÎóÌáʾÊÇʲô?
ÖØÆôһϻúÆ÷ÊÔÊÔ£¬
Èç¹û»¹ÊÇ·þÎñ²»ÄÜÆô¶¯µÄ»°£¬°ÑÄãµÄalert.logµÄ´íÎó¿¼³öÀ´¿´¿´¡£
ÏñÂ¥ÉÏËù˵µÄ£¬ÖØÆôһϻúÆ÷¡£È»ºóÔÙÆô¶¯Õâ¸ö·þÎñ£¬Èç¹ûÆô¶¯²»ÁË£¬Ó¦¸Ã»á±¨´í¡£°Ñ±¨´íÂëÌù³öÀ´¿´¿´¡£
Ïà¹ØÎÊ´ð£º
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
......
¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮
ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
Caused ......
ƽʱ¶¼ÊÇÁ¬½ÓMSSQL û̫עÒâÕâ¸öÎÊÌâ..½ñÌìÒòΪÐèÒª.ÔÚÍøÉÏÕÒÁËÒ»ÏÂ..Óкöà.. ¶¼ÊÔÁË.²»ÐÐ
ºÜ¶à¶¼ÊDZ¨:
δ´¦ÀíµÄÒì³£;System.Exception System.Data.OracleCilent ÐèÒª Oracle ¿Í»§¶ËÈí¼þ 8.1. ......
oracle text×öË÷Òýͬ²½µÄʱºò,Ó°Ïì²éѯÂð?ÈçºÎÖ¤Ã÷ÄØ?
ͬʱË÷Òýͬʱ²éѯ,²¢·¢½øÐÐͬһÌõ¼Ç¼
×Ô¼º¶¥Ò»¸ö
²Î¿¼£ºhttp://blog.csdn.net/fengzhu1008/archive/2009/01/15/3784853.aspx
text×öË÷Òý¡£ºÜ»áÓ°ÏìË ......