Array DML and BLOBs

[BobGeezer]

Mornin' Marco, All,

We can find no mention of Array DML used with
BLOBs. Is this possible? Do we "simply :-("
create an array of variants holding references to
TLOBLocator objects?

We're using array DML extensively in transferring
data from Interbase to Oracle. We've managed to
avoid BLOBs by squeezing our data into nvarchar
(2000)s.

However, today is crunch day! We have an
Interbase table with a MEMO column for which most
rows contain 3k up to 17k of information there.
We need an NCLOB.

Thanks in advance.

 

[BobGeezer]

I see now it is not possible :-(

I know we had problems with Direct Path Loader
originally, but can that load large CLOBs? We could have another try if so.

Reference for array DML:

"
Array DML does not allow for LOB Locators. It
only works with scalar data types like varchar2,
number, date, and so on.
Marco Kalter posted 14 April, 2006 09:42 AM
"

 

[Marco Kalter]

The Direct Path Loader should be able to load large CLOB's.