Re: UTL_FILE on multiple platforms

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Mon, 3 Mar 2003 02:39:18 -0500
Message-ID: <v661lg7besn5d@corp.supernews.com>

Don't get into this (9i onwards).
9i has the concept of DIRECTORY which should be used the way another poster has specified.

Anurag

"Rauf Sarwar" <rs_arwar_at_hotmail.com> wrote in message news:92eeeff0.0302282311.51ca680f_at_posting.google.com...
> greg_fenton_at_yahoo.com (mobiGeek) wrote in message news:<ea61f029.0302280734.685870cb_at_posting.google.com>...
> > I need to have my PL/SQL package run on both Windows and Solaris. In
> > my code, I am using utl_file to log debugging info.
> >
> > Currently my code looks like:
> >
> > v_dbg_file := utl_file.FOPEN( 'c:\tmp',
> > 'utl_file_SetSynchScripts.txt', 'a' );
> >
> > Is there a generic way to have FOPEN create its file without
> > specifying the directory?
> >
> > Failing that, is there a way that I can programmatically determine the
> > OS (or the machine name) on which the code is running so I can do
> > something like:
> > IF [running_on_windows] THEN
> > v_my_utl_directory := 'c:\tmp';
> > ELSE
> > v_my_utl_directory := '/tmp';
> > END IF;
> >
> > Thanks in advance,
> > greg_fenton.

>
>

> Another solution is using Java. if you are on 8i or above, create a
> small java stored procedure which will return file separator "\" for
> Windows and "/" for *nix.

>

> SQL> create or replace and compile java source
> 2 named "CheckOS"
> 3 AS
> 4 import java.io.*;
> 5 public class CheckOS {
> 6 public static String getSeparator ()
> 7 throws Exception {
> 8 return File.separator;
> 9 }
> 10 }
> 11 /

>

> Java created.

>

> SQL> create or replace function Check_OS return varchar2
> 2 as
> 3 language java name 'CheckOS.getSeparator () return
> java.lang.String';
> 4 /

>

> Function created.

>

> SQL> select Check_OS from dual;

>

> CHECK_OS
> ---------------------------
> \

>

> I ran this on Windows.

>

> Regards
> /Rauf Sarwar
Received on Mon Mar 03 2003 - 01:39:18 CST