Link to home
Start Free TrialLog in
Avatar of antenor
antenorFlag for Brazil

asked on

ADO and Field Blob - Oracle

my application is ported to Oracle, but i found ADO doesn't support BLOB
data type in Delphi 7 and "Microsoft OLE DB Provider for Oracle".
it could use driver of oracle, but I want to use of the Microsoft.
how to solve this problem?


thanks
Avatar of kretzschmar
kretzschmar
Flag of Germany image

what about

TBlobField(Dataset.FieldByName('fieldname')).Loadfromfile('imagefilename',ftblob);
//instead of Loadfromfile -> LoadFromStream would be also possible

not sure syntax about the last ftBlob-param

meikl ;-)
Avatar of antenor

ASKER

the Problem this at the moment that I go to Open the DataSet
>the Problem this at the moment that I go to Open the DataSet
what happens?
Avatar of antenor

ASKER

if the instruction sql to possess a field CLOB/BLOB occurs an error when trying to give a Open.
what dataset do you use?
is there any sql-statement in use?
Avatar of Kristao
Kristao

what !!!!!!!!! "found ADO doesn't support BLOB data type in Delphi 7" thats WRONG ADO supports it and i use them very often. And kretzschmars exsample should work.
ASKER CERTIFIED SOLUTION
Avatar of Mohammed Nasman
Mohammed Nasman
Flag of Palestine, State of image

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