DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OraOLEDB.Oracle generates error when retreiving a table with anydata col

565985May 29 2007

Hi,

I use OraOLEDB.Oracle to connect from VB6 to oracle, and ADODB recordsets.
I have a procedure that returns a table (using a cursor), the table has a column of type sys.anydata.
I get this error: ROW-00004: Invalid column datatype

I have to mention that it works excelent for anything that does not contain sys.anydata.

I use Oracle 9.2.

Thanks in advance,
pesq

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 26 2007

Added on May 29 2007

#oracle-provider-for-ole-db, #windows-and-net

0 comments

3,446 views