Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Spooling to a remote server

739411Dec 11 2009 — edited Dec 11 2009
Hi *
Is it possible to spool data from Oracle database (using PL/SQL script) to a remote server (without using ftp) such that the file that is created from the database saver is stored onto the remote server.
We do not want to make use of UTL_FILE.\

We are currently running our shell scripts from a remote server which connects to a database.
We want to stored procedures to create a file that will be stored onto the server that has our shell scripsts not on the database.

Could someone please show me an example on how to do that.

Thanks :)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 8 2010
Added on Dec 11 2009
2 comments
671 views