Re: utl_file oracle nt ?

From: Valent Levente <valentl_at_szabinet.hu>
Date: Wed, 21 Apr 1999 08:50:08 +0200
Message-ID: <7fjsjo$nt2@goliat.c3.hu>

I Hope this helps :

  procedure WriteFile(pc_Path Varchar2,pc_FileNev Varchar2) is     mn_File utl_file.file_type;
  begin
    begin
      mn_File:=utl_file.FOpen(pc_Path,pc_FileNev,'w');     exception
      when utl_file.invalid_path then Raise_Application_Error(-20000,'invalid_path');

      when utl_file.invalid_mode then Raise_Application_Error(-20000,'invalid_mode');

      when utl_file.invalid_operation then Raise_Application_Error(-20000,'invalid_operation');

    end;
    for i in yc_SQL.First..yc_SQL.Last loop     begin

      if yc_SQL.Exists(i) then
        utl_file.put_Line(mn_File,yc_SQL(i));
      end if; -- yc_SQL.Exists(i)
    exception
      when others then
        utl_file.FClose(mn_File);
        Raise;

    end;
    end loop;
    utl_file.FClose(mn_File);
  end;

Levente Valent
valentl_at_szabinet.hu

<tedchyn_at_yahoo.com> wrote in message news:7fhpkk$dkh$1_at_nnrp1.dejanews.com...
> sir, How do I use utl_in oracle nt ? Is there any difference between unix
and
> nt ?
>
> for example: file_hand:=utl_file(file_dir,file_lis,'R');
> file_dir = D:\....
> file_lis:=xxxx.sql
>
> example will be appreciated.
> Thanks Ted Chyn(respond to tedchyn_at_yahoo.com).
>
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Apr 21 1999 - 01:50:08 CDT