How i can store blob field in oracle10g

Posted on 2009-02-10
Last Modified: 2012-06-21
frist of all i ma not well speakinging english.
my problem is :
how i can store file with size for example 10mb or more in blob field or clob field
i am useing oracle10g ang delphi7
my table name is ingshow
fields are :
imgname varchar2(30)
sora blob
i want to store file with size 10 mb in field sora and how i can displyon delphi form
and when i run the program i recieve this error:0x77492b2f write of address0x00030ffc

acess violation at
plz help me
thxxxxxxxxxx alot

procedure TForm1.BitBtn1Click(Sender: TObject);


FileStream : TFileStream ;

buffer : String;

FileSize : integer;


FileStream := TFileStream.Create('d:\set.txt',fmOpenReadwrite) ;

FileSize := (FileStream.size );


memo1.text := Buffer;

 with query1 do




  sql.Add('insert into imgshow values('+quotedstr(edit1.Text)+',');




FileStream.Free ;


Open in new window

Question by:elmmahdi
    1 Comment
    LVL 7

    Accepted Solution

    say in your oracle database you have IMAGE coloum with BLOB data type and MEMO varchar(50)
    then do this
     sql.add(insert into imgshow (IMAGE,MEMO) values(EMPTY_BLOB()),:Memo);
     sql.add(returning IMAGE into :image);
     sql.ParamByName('image').AsParamType := ptInput;
     sql.ParamByName('image').AsBlobLocator.Asstring := quotedstr(edit1.Text);
     sql.ParamByName('Memo').AsString := quotedstr(memo1.Lines.Text);

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    squareUp  challenge 22 81
    copyEndy  challenge 15 40
    find a node in VST 2 37
    Installed softare without GUID 6 26
    This article will show, step by step, how to integrate R code into a R Sweave document
    A short article about a problem I had getting the GPS LocationListener working.
    In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now