OLE-Objects / ODBC

I'm using Ora 7.3 / ODBC Drv. V2.0.3.1.1 / MS Access97. The Ora-tables are attached to Acc97 by ODBC. I want to store OLE-Objects (e.g. Word-Docs, Excel-Sheets, etc.) in an Ora-Table.

1. Is the Ora-dataype long raw the correct datatype to store such informations?
2. I created the following table:

create table mytest ("key" number(8,0), "obj" long raw); alter table mytest add primary key ("key");

After inserting key and obj from Acc97 when updating the row the following error occures:

[Oracle][ODBC Oracle-Driver]Invalid value stored in pcbValue. (#0)

Any ideas?

3) Is there a way to use an Ora-Statement to insert an object? I'ld prefer to send such a statement as a passthrough from the Acc97-cllient instead of attaching the table.

Thanks in advance.

Heiko Falkenhof
NOSPAMFalkenhof_at_t-online.de Received on Mon Sep 21 1998 - 14:52:52 CDT