¶¯Ì¬SQLÓï¾ä²åÈë¿ÕÄÚÈݵ½blob×ֶΣ¨Oracle£©
ÔÚdelphiÖÐÓÃTSQLQuery¿Ø¼þÏòoracleÊý¾Ý¿âÖвåÊý¾Ý£¬ÆäÖÐÓÐÒ»¸öblob×ֶΣ¬¿ÉÒÔΪ¿Õ£¬Ð´ÁËSQLÓï¾äÈçÏ£º SQLQuery1.SQL.Text := 'INSERT INTO TestTable £¨ID£¬PIC£©VALUES£¨:id, :pic)'; SQLQuery1.parambyname('id').value := '001'; SQLQuery1.parambyname('pic').value := 'EMPTY_BLOB()'; SQLQuery1.ExecSQL(False); Ö´ÐÐʱ³öÏÖ:'SQL Server Error: ORA-01465:invalid hex number'µÄ´íÎóÊÇÔõô»ØÊ£¿ Èç¹ûд³ÉÏÂÃæÕâÑùÓÖ¿ÉÒÔ£¬ÓÖ¿ÉÒÔÕý³£Ö´ÐÐ SQLQuery1.SQL.Text := 'INSERT INTO TestTable £¨ID£¬PIC£©VALUES£¨:id, EMPTY_BLOB())'; SQLQuery1.parambyname('id').value := '001'; SQLQuery1.ExecSQL(False); ÓÐûÓÐʲô·½·¨¿ÉÒÔÔÚ¶¯Ì¬Óï¾äÖÐÖ´Ðвå¿ÕµÄBLOB×ֶΣ¿
Äãpic±äÁ¿ÉùÃ÷µÄÊÇʲôÀàÐÍ£¿ picÊÇBlob×Ö¶Î Êý¾ÝÀàÐͲ»Ò»Ö 'EMPTY_BLOB()',ÕâÊǸöʲô¶«Î÷£¬¿´ËÆÓ¦¸ÃÊÇÒ»¸ö·½·¨À´»ñȡͼÏñÄÚÈݰɣ¬Äã°ÑËüµ±³É×Ö·û´®¸³¸ø×Ö¶ÎÁË£¬¹À¼Æ¾ÍÊÇÕâ¸öÎÊÌâ NULLÒýÓà 'EMPTY_BLOB()',ÕâÊǸöʲô¶«Î÷£¬¿´ËÆÓ¦¸ÃÊÇÒ»¸ö·½·¨À´»ñȡͼÏñÄÚÈݰɣ¬Äã°ÑËüµ±³É×Ö·û´®¸³¸ø×Ö¶ÎÁË£¬¹À¼Æ¾ÍÊÇÕâ¸öÎÊÌâ oralce ÄÚÖú¯Êý empty_blob()Êǹؼü£¬ÎÒÖ»»áDOAµÄд·¨£¬ÒªÓõ½returning×Ó¾äÀ´·µ»Ø²ÎÊý¡£ADOûÊÔ¹ý£¬´ÓÀ´²»ÓÃADO·ÃÎÊORACLE¡£ лл´ó¼ÒµÄ°ïÖú¡£ ŪÃ÷°×ÁË£¬×îºóÕÒµ½ÁË·½·¨£¬·½·¨ÔÀ´ºÜ¼òµ¥£º SQLQuery1.parambyname('pic').value := ''; ÕâÑù¾Í¿ÉÒÔÁË¡£
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿ 1 ¿ÉÒÔɾ³ý 2 ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏ Errors in file /user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902: error in executing ODCIIndexStart() routine ORA-0 ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......