troubleshooting Question

how to use pl sql to export a csv file to another server

Avatar of ohmetw
ohmetw asked on
Oracle DatabaseJava
24 Comments1 Solution5991 ViewsLast Modified:
I need to schedule a job to  run a pl sql procedure that will create a csv file and send it to a directory path on another computer so it can be processed with some script.    I am using ORACLE SQL Developer to write my procedures, functions, and schedule the jobs.  I'm looking for a strategy to get the csv file saved to the directory path on another computer.  If you have multiple ideas for how to accomplish this please let me know.  I am most comfortable working within ORACLE and PL SQL.  Thanks!!!
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 24 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 24 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros