Link to home
Start Free TrialLog in
Avatar of elmmahdi
elmmahdi

asked on

How i can store blob field in oracle10g

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);
Var
FileStream : TFileStream ;
buffer : String;
FileSize : integer;
begin
FileStream := TFileStream.Create('d:\set.txt',fmOpenReadwrite) ;
FileSize := (FileStream.size );
Setlength(Buffer,FileSize);
FileStream.read(pointer(Buffer)^,FileSize);
memo1.text := Buffer;
 with query1 do
  begin
  close;
  sql.Clear;
  sql.Add('insert into imgshow values('+quotedstr(edit1.Text)+',');
  sql.Add(''+quotedstr(memo1.Lines.Text)+')');
  execsql;
 end;
FileStream.Free ;
end;

Open in new window

blobproblem.jpg
ASKER CERTIFIED SOLUTION
Avatar of tankergoblin
tankergoblin

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial