Re: ODBC Oracle Access and Raw problem

Keith,
Thanks for the response.

 It looks like installing this Oracle package will let me make SQL calls from OracleSQL that include a cast statement. (eg. Cast this Raw(16) Field to a varchar(8))

 While it is helpful, it doesn't allow me to use Microsoft Access to extract the tables.
I'd need to write a program with OracleSQL that talks to the Oracle database and extracts a row from the database, then write another program to somehow import
that data into Access. There is no Acess to Oracle connection here.

Jeff

"Keith Jamieson" <Keith.Jamieson_at_phoenix.ie> wrote in message news:8utr64$udd$1_at_kermit.esat.net...
> Install teh dbms_utlraw package. You can then convert raws to varchar, etc
> Jeff Siegel wrote in message <3a1050e8$1_at_rpc1284.daytonoh.ncr.com>...
> >I can't get Access to read a raw(16) type from Oracle 8i into a usable
> >format.
> >
> >It looks like Oracle's ODBC driver sends RAW fields to Access as Binary
> >types.
> >These "binary types" are not really useful in Access. A type of TEXT
> >would be more suitable. Ideally I'd like that field to show up as TEXT
 in
> >Access.
> >
> >I think this stuff came across as TEXT with Oracle 7.3, but I'm not
> >positive.
> >
> >Is there a way to do this? Or is this just Microsoft and Oracle not
 wanting
> >to talk to each other?
> >
> >
> >Thanks,
> > Jeff
> >
> >
> >
> >
>
>
Received on Wed Nov 15 2000 - 13:50:31 CST