Re: UTL_FILE package...need info

Ian Abramson wrote:
>
> I am running 73. on an IBM RS/6000. I want to be able to do file I/O in
> PL/SQL, and have installed and configured the UTL_FILE package.
>
> We have experienced some problems......
>
> The UTL_FILE_DIR = *
>
> This should mean that we can write to any directory...wrong!
>
> If we try to write to a user's directory, we get an error.
>
> ORA-6510 - PL/SQL unhandled user defined exception.
>
> This problem does not exist when we write to a dir under the Oracle home.

  The parameter specification UTL_FILE_DIR = * has a special meaning. This entry in effect turns off directory access checking, and makes any directory accessible to the UTL_FILE functions. However, the directory accessed must be Oracle accessible in OS level (not Oracle RDBMS level). Otherwise, any malicious can make use of this good chance.

-- 
Name        : Lun Wing San
Title       : Oracle developer of the Hong Kong Productivity Council
              System Administrator and Oracle DBA of the Quick Response
Center
Email Addr. : sunny_at_hkpc.org
Telephone   : 852-2788-5841