Re: Oracle User-Defined Types and ADO

From the OLE DB Provider (8.1.7.0.0) Release Notes (http://otn.oracle.com/docs/tech/nt/ole_db/doc/readme.txt):

...
5.5  The Provider does not currently support Oracle8i Object datatypes.
...

However, I believe that Oracle Objects for OLE *does* provide support for Object datatypes.

It has been awhile since I was doing development on a regular basis. There is a book published by Sybex called "Oracle and Visual Basic Developer's Handbook" that would cover this topic. It is by Oracle staff members Jim Fedynich, Jenny Besaw and Mark Tomlinson. ISBN is 0-7821-2476-3.

Also see (http://technet.oracle.com/tech/nt/ole_db/) if you haven't already...

HTH "No Name" <fakeadress_at_fake.com> wrote in message news:4YR27.105$xW3.19472_at_newsread2.prod.itd.earthlink.net...
> Windows 2k
> Oracle 8.1.7
> ADO 2.6
> VB 6
>
> Hello,
> Have been working with ADO and Oracle for a long time and have been
 pleased
> with the results. Now I've been looking into the all of the possibilities
> with Oracle's user-defined types and object tables, etc. Just as a quick
> test, I created a datatype and used it in a table definition. Then if I
 do
> a "select * from mytable" with ADO it tells me that my new datatype is not
> supported.
> I tried both Microsoft and Oracle's OleDB providers.
>
> So tell me, am I just completely screwed in trying to use these Oracle
> features with a VB application???
>
> Thanks!
>
>
Received on Wed Jul 11 2001 - 22:29:30 CDT