Oracle Blob and access 2003

I'm using an ADO command object and oracle stored procedures to
upload/download a word document file to a blob column to an access
application.

Uploading seems to go fine - the blob row is created and the size in the db
matches the file I sent it.

Downloading is another matter - somewhere along the line, the file is losing
50% - always exactly 50% too... a 76244 byte file comes back as 38144 an
84200 byte file comes back as 42100...

The size I'm giving in the paramater for the command is always double the
actual file size

If I link the table to access, the column comes back as an ole object and the
length of the data in the column is also exactly half of what I loaded in the
oracle db.

Anyone have any ideas?

In way over my head here ... but sort of sounds like some kind of
double-byte to single-byte character loss might be happening ????

--
Clif

"weblevins" <u55939@uwe> wrote in message news:9e93129a13f72@uwe...
> I'm using an ADO command object and oracle stored procedures to
> upload/download a word document file to a blob column to an access
> application.
>
> Uploading seems to go fine - the blob row is created and the size in
> the db
> matches the file I sent it.
>
> Downloading is another matter - somewhere along the line, the file is
> losing
> 50% - always exactly 50% too... a 76244 byte file comes back as 38144
> an
> 84200 byte file comes back as 42100...
>
> The size I'm giving in the paramater for the command is always double
> the
> actual file size
>
> If I link the table to access, the column comes back as an ole object
> and the
> length of the data in the column is also exactly half of what I loaded
> in the
> oracle db.
>
> Anyone have any ideas?
>



--
Clif