471,108 Members | 1,294 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,108 software developers and data experts.

How to insert BLOB?

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

Jul 19 '05 #1
2 17619
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

Jul 19 '05 #2
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


Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Ole Hansen | last post: by
2 posts views Thread by Niraj | last post: by
11 posts views Thread by Chris Fink | last post: by
1 post views Thread by cricrin | last post: by
6 posts views Thread by Gregor =?UTF-8?B?S292YcSN?= | last post: by
2 posts views Thread by Ole Hansen | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.