Re: UTL_FILE - How do I call its funcs/procs form a stored proc

You'll also need the following entry in your init<SID>.ora file

utl_file_dir=/unixdirectory

To allow the server access to the directory.

Thomas Kyte wrote in message <3637e9b3.6618637_at_192.86.155.100>...
>
>Well, fopen is defined as:
>
>FUNCTION FOPEN(location IN VARCHAR2,
> filename IN VARCHAR2,
> open_mode IN VARCHAR2)
>RETURN UTL_FILE.FILE_TYPE;
>
>
>so, a block of code (or proc/func) that wanted to use fopen would code:
>
>
>
>declare
> l_output utl_file.file_type;
>begin
> l_output := utl_file.fopen( p_dir, p_fname, 'w' );
> ....
Received on Tue Oct 27 1998 - 10:04:33 CST