Home » SQL & PL/SQL » SQL & PL/SQL » Writing to a file from PL/SQL procedure
Writing to a file from PL/SQL procedure [message #233284] Wed, 25 April 2007 09:14 Go to next message
Messages: 5
Registered: April 2007
Location: Kolkata
Junior Member
I want to create a new file and write to the file from PL/SQL procedure. The procedure is alraedy in place and is working fine. I created a new directory in oracle using create directory command and granted read, write priviledge on the directory to public. The required directory has been created in the server as well.

However when I execute the peocedure it is giving 'Path Not Found' exception and no file is being created in the directory.
Can you suggest how can i get the procedure to execute successfully.
Re: Writing to a file from PL/SQL procedure [message #233334 is a reply to message #233284] Wed, 25 April 2007 13:30 Go to previous message
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
Can you post the relevant parts of the procedure?
Previous Topic: trigger to call a batch file
Next Topic: How do you count explicit nested_table and incorporate it in the logic
Goto Forum:

Current Time: Thu Aug 17 12:41:25 CDT 2017

Total time taken to generate the page: 0.07960 seconds