For me the URL was working after copying to the browser (clicking was not wokring).

It is quite disappointing if there is no other (faster and easier) way to archive and...

Thanks for this link, I have checked it and it seems the actual registry settings are not valid. In the past the Oracle client was upgraded but the registry settings...

Do you mean I create a #temp table with a text column, and I concatenate the result there in 1 row?

This part of the task is ok, but how can...

I tried to find a way to put the result into a text, but I have not found the way, how could I achieve that.

As I know I cannot declare...

It is a recordset.

But in SPOnServer2 I can put it into a varchar(8000) variable (in XML format), which is accceptable only if the data fits into 8000 chars.

SPOnServer2 is very...

Sorry, I know my problem description is not so simply, but the problem is also a bit more difficult:)

So the data needs to go on this way back:

OracleDB -> Server2...

What is really annoying me is that I can see the result many ways on Server2, if I execute e.g. in Query Analyzer:

1. exec SPOnServer2 'param1', 'param2'

2. or I can...