selecting empty blobs

[ahancock]

I am using a TOracleDataSet to return a result set. This needs to include an empty_blob for the application so:

select ID, EMPTY_BLOB() B from TEST

This yields an ORA-22275 "invalid
LOB locator specified".

How do I achieve this. I have tried OracleSession.NullLOBisEmpty := true.

I need the result set in an OracleDataSet to pass this to another application through a provider.

thanks in advance

 

[Marco Kalter]

Apparently the empty_blob() function returns an invalid LOB Locator, and not an empty one. This is probably caused by the fact that this empty blob is not part of a database record. Do you really need this empty blob in the result set?

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

 

[Andi]

Hi,

in need the empty_lob() im my resultset (becase of strucutures that are hardcoded in the client an require the blob-field with the blob-type).

Could you implement it? Or is there a hidden feature?

Thanks!

Best Regards,

Andi

 

[Marco Kalter]

As a workaround you can create a function that returns an empty temporary BLOB:

create or replace function dummy_blob return blob is
  Dummy blob;
begin
  dbms_lob.createtemporary(lob_loc => Dummy,
                           cache   => False);
  return(Dummy);
end;

This can be queried instead of empty_blob().