oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í£Ö¹¡±×´Ì¬£¬Æô¶¯²»ÁË£¬Ò²¹Ø±Õ²»ÁË¡£
ÔÚÏߵȸßÊֻشð!ллÏÈ£¡
´íÎóÌáʾÊÇʲô?
ÖØÆôһϻúÆ÷ÊÔÊÔ£¬
Èç¹û»¹ÊÇ·þÎñ²»ÄÜÆô¶¯µÄ»°£¬°ÑÄãµÄalert.logµÄ´íÎó¿¼³öÀ´¿´¿´¡£
ÏñÂ¥ÉÏËù˵µÄ£¬ÖØÆôһϻúÆ÷¡£È»ºóÔÙÆô¶¯Õâ¸ö·þÎñ£¬Èç¹ûÆô¶¯²»ÁË£¬Ó¦¸Ã»á±¨´í¡£°Ñ±¨´íÂëÌù³öÀ´¿´¿´¡£
Ïà¹ØÎÊ´ð£º
¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮
ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
Caused ......
ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ
DB2ÖÐÈçºÎʹÓÃÐ ......
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
oracle text×öË÷Òýͬ²½µÄʱºò,Ó°Ïì²éѯÂð?ÈçºÎÖ¤Ã÷ÄØ?
ͬʱË÷Òýͬʱ²éѯ,²¢·¢½øÐÐͬһÌõ¼Ç¼
×Ô¼º¶¥Ò»¸ö
²Î¿¼£ºhttp://blog.csdn.net/fengzhu1008/archive/2009/01/15/3784853.aspx
text×öË÷Òý¡£ºÜ»áÓ°ÏìË ......