Thanks everyone for you comments.

I have solved the issue.

It had to do with the registry for MSDTC did not have the proper names of the ORACLE OLEDB Provider DLL's.

I believe...

I investigated the MtxOCI.dll path and found a document that pointed me to some registry settings.

When I looked they where using ORACLE 8 DLL references.

I changed them to the 10g...

Thanks for the help.

I am looking into if the MtxOCI.dll file is loaded.

I am unfamiliar with this file.

All of my functions to ORACLE work very well as far as executing...

WOW You assume to much. I am seeking help not abuse!

I have read everything available on the subject. So have the engineers on the ORACLE side.

Yes MSDTC is running and...

Thanks for your response.....Sorry for the cross post.

According to BOL the transaction is automatically upgraded to a Distributed Transaction when using a Linked Server Call.

If I code a Distributed Transaction...

Yes That was the original plan.

To send the XML directly to ORACLE.

PROBLEM 1:

The OLEDB providers for ORACLE from Microsoft and ORACLE will not allow an XML variable as a PARAMETER.

Solution...

I believe we are barking up the wrong tree.

The fetch into does not support Table Variable so I am assuming it will not support XML variable.

If you find something different...

OOPS...My order is a little screwed up.

I NULL out the XML Variable before I fetch Next

here is my cursor code. Sample data is harder as it is from a view.

Normally I would Fetch into variables but I need to Fetch into an XML Variable

declare HeaderCursor...

Charity is good for the SOUL, and in this case ME 🙂

Have a good week.

Mike

Lutz,

Thank you very much!!!!

This will be very helpful

Sorry about the data....It will not happen again.

Regards

Michael Hilligas

Lutz,

It is nice to hear from you again.

Thanks for the advice. I have looked at the articles.

I have a working knowledge of SQL, but this is getting pretty intense for...

Here is the Create Table Script and a CSV file to import for the data.

TempTableForPIVOT.txt

TempTableForPIVOT_Data.txt

I would liketo see the output pivot to look like this the enclosed excel sheet.

PivotOutput.xlsx

Lutz,

Thanks for your reply.

I have tried to send the xml variable in the SP call but the MSDAORA OleDB Provider does not like it.

I need to spend some time, IF...

Imu92....

Thanks again for your help.

I have one more question.

Is there any way to pass a Table as a parameter to a SP in SQL 2005

One other issue is that the...