I have a stored procedure that creates a comma delimited
file. I can easily write to a directory on the database server, but I would
like to write the file to a mapped network directory on a NAS server. The
issue, at least conceptually (sorry for being a novice here), is that I have no
way of accessing or embedding the necessary username/password to write to the
Based on initial research, it looks like the oracle account
is the one writing the file. Would that mean that the oracle account would have
to have the appropriate privileges to the NAS directory? Who would that oracle
user be? The niku account user being used to execute the proc?
Kind of lost here. Would like to send directly to the NAS to
avoid an SFTP to another environment.
View Complete Post