In an application, you need to use two blob fields in the same table (you can also use the long Raw field, but one table in Oracle can only have a long RAW):
Create Table DOCS
? id? Number construint pk_docs primary key,
DOC BLOB
);
However, some questions are found in operation, using the following statement to write blob:
Table1.insert;
Table1ID.Asstring: = 111;
Table1Doc.LoadFromFile (f); ??? //table1doc.datatype: = ftablob;
Table1.post;
There is no problem with the length of the blob field after POST, but it is in the utilization of DBMS.GETLENGTH (DOC)
Table1.open;
Table1doc.savetofile (f);
When the statement, it is found that the exported file will make more bytes (files may not be time). The same is true of the same clob field. I think this is probably a bug of D5? Finally, only use longrawc to solve the problem, you have to build two tables, I don't know how to support BLOB in D7?
Test environment: Delphi5 Oracle 8.05
?