Thanks for the question, sahul.
Asked: November 30, 2009 - 12:09 pm UTC
Last updated: December 01, 2009 - 4:37 am UTC
Version: 9.2.0
Viewed 1000+ times
You Asked
Dear ,
I wrote utl_file package to get the data from oracle apps table.
In test instance i got the file in respective path with exact data.But in production instance i couldnt see the output file.I changed the production dir path also.Can you explain whats the problem.For oracle apps utl_file output directory i got the path from "select * from all_directories". The only thing what i am seeing is
in the test instance i didnt create the folder it was already existing .But in production instance thers was no path existing like mentioned in all_directories.So I created the folder like the same in windows OS using NewFolder.
Thanks in Advance
A.Sahul Hameed
and Tom said...
I'll bet your code has a "when others" in it, and there is no raise or raise application error following it.
And you are hitting an error - the error is "directory does not exist". But you never see this because your code hides this error.
You have to create the OS directory, we cannot do that.
So, on production make sure the directory exists and that it is readable and writable by Oracle.
Is this answer out of date? If it is, please let us know via a Comment