TLOBLocator

[edennis]

I really need your help!,

I'm trying to translate a DBASE (Data and Images) files to Oracle.

I already open both database, for DBASE I and using BDE and for Oracle DOA 3.4.6.

I don

 

[Marco Kalter]

The error message suggests that the TLOBLocator was not initialized on the server. You should insert an empty_blob() into the BLOB column, and return this initialized BLOB into the TLOBLocator variable:

insert into [TABLE]
  (..., your_blob_column, ...)
values
  (..., empty_blob(), ...)
returning your_blob_column into :your_blob_variable

After this statement has executed, you can write the data.

------------------
Marco Kalter
Allround Automations

 

[edennis]

Excelent! but, do you know how can i load the Image into de buffer array?

Thanks you very much!

 

[Marco Kalter]

All you need is the address of the image data and its size, so that you can pass this information to TLOBLocator.Write. I'm not really a TImage expert though, so I couldn't say how this works.

------------------
Marco Kalter
Allround Automations

 

[edennis]

Thanks you soo much.

I do it like this:

Img_stream := TBlobStream.Create(tblobfield(dbase.fieldbyname('firdata')), bmRead);

img_size := lob1.CopyFrom(Img_stream, Img_stream.Size);

Regards.