SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

UTL_FILE privileges

Sagar DApr 20 2016 — edited Apr 21 2016

I am getting an error as

Error(3,8): PLS-00201: identifier 'UTL_FILE' must be declared

while compiling a procedure with user XYZ that requires two declarations as follows:

v_file UTL_FILE.file_type;
v_string VARCHAR2 (4000);

Later i used the same procedure for compiling with user ABC that has SYS privileges. No errors were encountered while compiling from user ABC. I need to know the exact privilege required for this scenario. SYS privileges can't be given to user XYZ. Will the CREATE ANY DIRECTORY privilege help me in any way? Can you help me getting a solution for the problem?

This post has been answered by Kalpataru on Apr 20 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 19 2016

Added on Apr 20 2016

12 comments

537 views