How to insert BLOB?

[Ole Hansen]

Hi,

Is it possible to insert BLOB data without doing a select first? I have
data available and want to insert a row with BLOB data.

Should I use the callback function with OCILobWrite() or is it not
possible at all without doing a select?

How about using a temporary LOB? I have tried everything I could come up
with but nothing seems to work.

Thanks in advance?
Br,
Ole Hansen

[SoftwareEngr]

Use GetChunk and PutChunk methods of adodb.recordset
hope that would do
Ole Hansen <rm*******@city.dk> wrote in message news:<3f***********************@dread16.news.tele. dk>...

Hi,

Is it possible to insert BLOB data without doing a select first? I have
data available and want to insert a row with BLOB data.

Should I use the callback function with OCILobWrite() or is it not
possible at all without doing a select?

How about using a temporary LOB? I have tried everything I could come up
with but nothing seems to work.

Thanks in advance?
Br,
Ole Hansen

[Ole Hansen]

Im using the array interface with OCI but still have problems although I
now succeeded inserting one row with BLOB columns.

Thanks.
Ole
SoftwareEngr wrote:

Use GetChunk and PutChunk methods of adodb.recordset
hope that would do
Ole Hansen <rm*******@city.dk> wrote in message news:<3f***********************@dread16.news.tele. dk>...

Hi,

Is it possible to insert BLOB data without doing a select first? I have
data available and want to insert a row with BLOB data.

Should I use the callback function with OCILobWrite() or is it not
possible at all without doing a select?

How about using a temporary LOB? I have tried everything I could come up
with but nothing seems to work.

Thanks in advance?
Br,
Ole Hansen