when i generate a file using utl_file package, the permisions are 644. I require the permissions to be changed to 664. how can i do this. I guess this package uses umask set some where. How do i change that default umask value.
Correct, by default files created with UTL_FILE are created by the owner associated with the Oracle process. Therefore, the owner's umask will be applied to the files. You would have to changed the umask associated with the owner of the oracle process. You can change the default umask by setting umask 113 (in your case) in the .profile or .login file.
Thanks for your answer. But i have a doubt. When the utl_file package is executed from the procedure, i guess it does not execute the .profile/.login of the oracle process. So how does the setting in .profile take effect.