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

ÔõôÓÃdelphi¶ÁÈ¡³öOracleÖеÄBlobͼƬ²¢ÏÔʾ³öÀ´£¿

±¾ÈËÏë×öÒ»¸öÏÔʾOracleÖÐͼƬµÄ½çÃæ£¬µ«ÊǽñÌìÉÏÍøÕÒÁËÒ»ÌìҲûÓз¢ÏֱȽÏÏêϸµÄ½éÉÜ£¬¶¼Ìáµ½ÒªÓÃTTableºÍTDatabase£¬µ«ÊÇÎÒÅä²»¶ÔTTable£¬×ÜÊDZ¨"general error ORA:90036 ȱʧ±í´ïʽ"µÄ´í£¬ÄÄλ¸ßÊÖÄܸøÖ¸µãϰ¡
×îºÃÄÜÓиö¼òµ¥µÄʾÀý£¬½²½âÏÂÔõôÍê³É¶ÁȡͼƬµÄ£¬Ð»ÁË¡£
LazarusÉÏÓиö TOracleConnection ¿Ø¼þ£¬DelphiÉÏû¸ã¹ý£¬°ï¶¥¡£

blob¸ñʽµÄÎļþÐèÒªÓøöAPIº¯ÊýÀ´²Ù×Ý£¬¾ßÌåµÄÄãËÑË÷һϡ£

ѧϰ



ÒýÓÃ
Èç¹ûÄã×°ÁËOracle¿Í»§¶ËµÄ»°¾ÍÖ±½ÓÓÃADO¿Ø¼þµÄOracle Provider for OLE DB¾Í¿ÉÒÔÁ¬½ÓÊý¾Ý¿âÁË¡£²»ÒªÓÃMicrosoft OLE DB Provider for Oracle²»È»¾Í»á±¨²»¼¼ÊõBlob¸ñʽµÄÊý¾Ý¡£
var mem:Tstream;
jpeg:TJpegimage;
begin
    jpeg:=TJpegimage.Create;
    mem:=adoquery1.CreateBlobStream(adoquery1.FieldByName('pic'),bmRead);
    mem.Position:=0;
    if mem.Size>0 then begin
    begin
      jpeg.LoadfromStream(mem);
      image.Picture.Assign(jpeg);
    end;
end;

Èç¹ûûÓа²×°¿Í»§¶ËµÄ»°¾ÍÒªÓõÚÈý·½¿Ø¼þODACÁ¬½Ó¡£¶ÁÈ¡·½·¨ºÍÉÏÃæÒ»Ñù¡£


ÎÒÊÔ¹ýÓÃadoquery£¬¿ÉÊÇÀïÃæµÄsqlÓ¦¸ÃÔõôд°¡£¿
blob×ֶβ»ÄÜÖ±½Óselect°¡

ÒýÓÃ
var 
  pjpg:tjpegimage; 
  pic:TMemoryStream; 
  begin 
  pjpg:=tjpegimage.Create; 
  pic:=TMemoryStream.Create; 
  TBlobField(dataset.FieldByName('Img')).savetoStream(pic); 
  pic.posit


Ïà¹ØÎÊ´ð£º

OracleÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

oracle 10g°²×°µ½85%ʱ±¨´í

¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿

ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..

ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......

oracle spatial¿Õ¼äº¯Êý³ö´í - Oracle / ¸ß¼¶¼¼Êõ

ÔÚÖ´ÐаüµÄʱºòÒýÓÃ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 ......

server 2000Êý¾Ý×ªÒÆµ½oracle - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔ­À´oracleÀïµÄÔ­ÓеÄÊý¾Ý¿â,Ö»ÄÜн¨

ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ