If you are using PL/SQL for this, unless I’m mistaken, any file activity is done on the Oracle server. Which means that not only do you need rights to the file system on the server, you have to be able to either access the file system from a local computer to get the files once they are written there, or the server needs to be able to access another server or your local computer to move said files to a location that you can then access.
Our DBAs here are very hesitant(read this to mean that we’ve never come up with a valid reason for them to give us this ability) to allow access us access to write to the server and our Oracle server is set up so it can’t get to the other servers easily.
Unless you have a compelling reason for this process to be done via pl/sql, you might be better off finding another way to get your spreadsheets automatically, such as using the automation designer + windows scheduler or another program.
On Thu, Mar 19, 2015 at 10:20 AM, John Dorlon firstname.lastname@example.org wrote:
RE: Automating Spreadsheet export with PL/SQL?
Reply by John Dorlon
Toad’s going to be able to see whatever folders you can see in MS Explorer on the machine that Toad is installed. I’ve never tried to look at a mapped drive from Oracle, but it sounds like the Oracle user on the server doesn’t have privileges to the mapped drive.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag this post as spam/abuse.
Digital Strategies, Cru | Data Sciences & Analytics