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!

xml output oledb

507899Apr 21 2006

Hello, a very good day to you!
I'm having a problem i'm not able to solve:
I would like a sqlstatement to output in xml format.
the following statement works fine in TOAD:
SELECT XMLELEMENT(\"ROW\", XMLATTRIBUTES(JOBID, JOBDESCR)) HENK FROM ISH.JOB.
But when i offer it to the oracle OLEDB provider i get the cryptic message:
ROW-00004: Invalid column datatype.
Can somebody help me please.
Much obliged.
Henk Spaan

Locked Post

New comments cannot be posted to this locked post.

Locked on May 19 2006

Added on Apr 21 2006

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

0 comments

1,824 views