Hi all,
I am accessing a Oracle Database for DTS using MS ODBC driver.
The simple queries can easily provide the data required over the DTS,
however i am unable to access certain queries which have been written
using Cursors (utl_file.put_line) where the Query is designed to
provide the output into a text file.

We have minimal (query only) access to the oracle Db and it is not
possible for us to use anything like a temp /staging table to output
the info.

I really wish to avoid getting major chunks of data over to the SQL
system and carry out manipulations there as the SQL system is running
on very low end HW (1 cpu 256 mb P3 someone old desktop actually)

I have no knowlegde of oracle and am stumped.

Any suggestions on how to handle this would be extremely helpful.

Thanks & Regards,
Abhishek