Re: UTL_FILE on multiple platforms

Thomas Gaines wrote:

> mobiGeek wrote:
>
> > 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?
> >
>
> Don't know.
>
> >
> > 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;
> >
>
> I'm sure that there's a more elegant way to do this, but one approach
> that immediately comes to mind is to check the value of a particular
> initialization parameter. For example, check the value of "control_files"
>
> (i.e. select value from v$parameter where name = 'control_files';,
> assuming
> that you have the proper privileges). If the values contain a Unix-type
> file spec, then your OS is Unix. You get the idea.
>
> Bye,
> TG
>
> >
> > Thanks in advance,
> > greg_fenton.

What you suggest will work just as looking at the placement of datafiles will work ... does the name contain forward or backward slashes.

What I find a total showstopper is the thought that you can get a SysAdmin or DBA to give permissions to /tmp just because that is how you configured your product. I'd say "fat chance". The location of the utl_file directory should be dynamically installation configurable: Not hard coded into a procedure.

Anyone thinking they are going to sell a commercial product that hard codes a path is going to get more grave disappointment than sales.

Daniel Morgan Received on Fri Feb 28 2003 - 15:35:35 CST