Hi can u give me the info abt how can we pass the arg to the oracle procedures
how can i delete the csv file from oracle procedures
views:
29answers:
1
A:
You can use the UTL_FILE package to interact with system files located on the server. You should read the documentation to learn how to setup your environment. Once you have created the directory you want to access in oracle (here named DIR), this command will delete a file:
utl_file.fremove('DIR', 'FILE_NAME');
Vincent Malgrat
2009-06-18 08:14:26
It should be pointed out that UTL_FILE files are located on the database server itself, not client-side.
Thilo
2009-06-18 08:16:49
@Thilo: you're right, I updated my answer. It should be clearer now, thanks.
Vincent Malgrat
2009-06-18 08:39:30