[suse-oracle] OCI BLOB INSERT

From: Ole Hansen (oha@city.dk)
Date: Mon Sep 01 2003 - 14:21:05 CEST

• Next message: Ole Hansen: "[suse-oracle] OCI: How to insert BLOB?"
• Previous message: Uwe Teichmann: "Re: [suse-oracle] 8i and 9iR2 on same box?"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

From: Ole Hansen <oha@city.dk>
Message-Id: <1062418864.1833.18.camel@mygentoo.mydomain.com>
Date: 01 Sep 2003 14:21:05 +0200
Subject: [suse-oracle] OCI BLOB INSERT

Hi,

I would like to insert BLOBs into a table. Is it possible to populate
the BLOB value without doing a SELECT for the locator first?

I have all data available and want to insert BLOBs into a NEW row,
perhaps mixed with some other columns. Do I really need to first insert
an empty locator, select it, and then populate with data? Isnt it
possible to write the BLOB value directly? I have been looking A LOT
into Oracle documentation, and maby OCILobCreateTemporary() is the
solution - or is it?

If this is possible - how should the locator be initialized then? By
OCIAttrSet() and OCI_ATTR_LOBEMPTY?

If somebody has an example, I will be very happy.

Thanks in advance.

Br,
Ole Hansen

---------------------------------------------------------------------
To unsubscribe, e-mail: suse-oracle-unsubscribe@suse.com
For additional commands, e-mail: suse-oracle-help@suse.com
Please see http://www.suse.com/oracle/ before posting

• Next message: Ole Hansen: "[suse-oracle] OCI: How to insert BLOB?"
• Previous message: Uwe Teichmann: "Re: [suse-oracle] 8i and 9iR2 on same box?"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

This archive was generated by hypermail 2.1.7 : Mon Sep 01 2003 - 14:25:52 CEST