Operate the BUG of Oracle's BlobClob field in Delphi5.

xiaoxiao2021-03-06  108

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

?

转载请注明原文地址:https://www.9cbs.com/read-125191.html

New Post(0)