Which exception is used in utl file package in pl/sql

Improve this answer. Angelo Fuchs Angelo Fuchs 9, 29 29 silver badges 68 68 bronze badges. LukeWoodward Yes. Thank you. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Thank you for this information. I am getting the same error as Greg. Did you figure it out Greg? Thanks in advance.

Very useful for freshers and showing working example. Hi, Well explained!!! I have set the parameter in init. Hi, Please send your code for analysis. If all the permissions are correct then check whether your varables are being initialized properly or not. Send money home in a jiffy. No redistribution. You could win one. No Account? Sign up. By signing in, you agree to our Terms of Use and Privacy Policy.

However, the server implementation might be running in a privileged mode, and will need additional security restrictions that limit the power of this feature. Accessible directories must be specified in the instance parameter initialization file INIT.

For example:. Note: The directory specification is different on different platforms. Oracle does not recommend that you use this option in production systems. Also, do not include '. In the normal case, this owner is oracle.

Caution: There are no user-level file permissions. This can override operating system file permissions. Users of the package should not reference or change components of this record. File location or filename was invalid. Opens a file for input or output with the default line size. PUT procedure Writes a line to a file. This does not append a line terminator.

This appends an OS-specific line terminator. Thus, the default which is on most systems is used.