Also, please be informed that I have SQL*plus, access through UNIX as well. Suggestions are most welcome.
Hi Team, can anyone advise if I have posted this query in inappropriate forum. Normally I have seen other posts are answered reasonably at a faster pace. Please help me.
I guess you should post this in the SQL Developer forums. However; if you don't mind using other tools I have an idea: recently a feature has been added to the free mod_owa module to output a ref cursor in various formats; e.g. in CSV:
so in essence you'd need a stored procedure returning ref cursors and an apache with the module configured. You'd simply have to do HTTP Requests and store the response in a file.