Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2010

    Unanswered: access to utl_file package

    Hi ,

    I am trying to use utl_file package inside my test package and i am getting an error but when I am running the same piece of code using anonymous block it is working OK.

    I have attached the code and error.

    I think some sort of permission issue with the directory object PPP_LOG_DIR

    Please advice

    Cheers !
    Attached Files Attached Files

  2. #2
    Join Date
    Jun 2004
    Liverpool, NY USA
    I do not open attachments. Please paste the file into the body of the thread.
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    Privileges acquired via ROLE do NOT apply within NAMED PL/SQL procedures.
    Direct GRANT must be issued to avoid the error.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts