Thnx for the reply. I have been loading into a temp table and joining with sql server tables, to get around the problem, that works fine. I would prefer not...

Here is a link from another post that might help you or at least give you clues as to how to solve your problem

http://p2p.wrox.com/topic.asp?TOPIC_ID=15542

Please note this was...

While I am trying to figure this out, do you have any oracle stored procedures that returns a REF cursor and you tried executing it in sqlserver. If you were...

Jeff & Sveg,

Jeff:

I will look into your suggestion to see if it is possible, Oracle stored procedure that returns a REF cursor has...

Jeff,

I created link sever using "Microsoft OLE DB Provider for Oracle", it works, it does not with "Oracle Provider for OLE DB".

You are 100% right...

Jeff,

I put it in caps the way you wrote it and ran it, same error. I have a feeling, my link server is not established...

I am also establishing a linked server, running into some problems. You may need to change the registry entires for 9i, similar to what I did for 10g.

See my...