Perl is *much* more flexible than UTL_FILE for flat file operations.
There is simply no basis for comparison.
The question in your case is this: Can you easily replace the PL/SQL
procedures that are using UTL_FILE with a process that runs outside
of the database?
If so, myself and others on this list can point you in the right
direction, as
basics in Perl/Oracle/DBI are really not too hard.
If your PL/SQL is part of a larger application and not easily removed, you
may just have to deal with modifying the PL/SQL.
Of course, if you had made this stuff data driven ( meta data, if you will
),
this would be a non-issue. :)
Jared
John Dunn <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
02/27/02 01:53 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: moving from unix to NT
Thanks to everyone for their input into this. The only real issue seems to
be UTL_FILE on network drives.
1. I was interested in the many references to Perl as an alternative to
using UTL_FILE. Could any of you provide more detail. I know nothing about
Perl so would be interested in how to replace the use of UTL_FILE in
PL/SQL
with Perl. We use UTL_FILE quite a lot for reading and writing flat files.
2. With regard to external procedures, On Unix we currently use this to
call
a C routine that calls the system command to run Unix commands and
scripts(Korn Shell). I presume we will need to amend these commands to
their
NT equivalents(or can I call Windows API directly from PL/SQL? on NT) and
re-write the scripts...presumably in Perl?
It will probbably be Oracle 9i on NT.
John
> -----Original Message-----
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: 26 February 2002 21:37
> To: Multiple recipients of list ORACLE-L
> Subject: Re: moving from unix to NT
>
> I haven't tried to do this with Oracle, I just knew that you could.
>
> My use has been to change the account that is used for some of my
> monitors that need to see network drives. I've never had a need
> to make Oracle run as other than System.
>
> As for UTL_FILE, I avoid it like the plague. Perl is much cleaner
> and easier to use.
>
> Jared
>
>
>
>
>
>
> "Igor Neyman" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 02/26/02 10:53 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc:
> Subject: Re: moving from unix to NT
>
>
> Well, I was having all kinds of problems, when I was playing with this
> option, trying to make oracle service on nt to run under other then
SYSTEM
> account. And yes, I granted this account any possible NT privilege
(like
> ability to run/logon as a service), still didn't work.
>
> Jared,
>
> Could you share some details on this issue, if you still remember how
you
> managed to make this working?
>
> Igor Neyman, OCP DBA
> [EMAIL PROTECTED]
>
>
> ----- Original Message -----
> To: <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Tuesday, February 26, 2002 1:14 PM
>
>
> > > Because Oracle on NT runs (hence executes UTL_FILE) under SYSTEM
> > account,
> > > which does not have privileges to access network drives.
> >
> > You can change that if you're so inclined.
> >
> > ( I can't believe I'm defending Windoze. shudder )
> >
> > Jared
> >
> >
> >
> >
> >
> >
> >
> >
> > "Igor Neyman" <[EMAIL PROTECTED]>
> > Sent by: [EMAIL PROTECTED]
> > 02/26/02 06:23 AM
> > Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> > cc:
> > Subject: Re: moving from unix to NT
> >
> >
> > Well, you shouldn't:)
> >
> > Because Oracle on NT runs (hence executes UTL_FILE) under SYSTEM
> account,
> > which does not have privileges to access network drives.
> >
> > Igor Neyman, OCP DBA
> > [EMAIL PROTECTED]
> >
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Monday, February 25, 2002 9:38 PM
> >
> >
> > > On UTL_FILE, I've never had much luck using network mounted files.
> > >
> > >
> > >
> > > Igor Neyman
> > > <ineyman To: Multiple recipients
> of
> > list ORACLE-L
> > > @perceptron.c <[EMAIL PROTECTED]>
> > > om> cc:
> > > Sent by: root Subject: Re: moving
from
> > unix
> > to NT
> > >
> > >
> > > 02/25/2002
> > > 12:18 PM
> > > Please
> > > respond to
> > > ORACLE-L
> > >
> > >
> > >
> > >
> > >
> > >
> > > For external procedures just follow the rules for creating DLLs on
NT,
> > > works
> > > fine.
> > >
> > > DBMS_JOB works fine.
> > >
> > > For UTL_FILE make sure, you are following NT conventions, when
> > specifying
> > > file path(use back slash '\', not front slash '/').
> > >
> > > Igor Neyman, OCP DBA
> > > [EMAIL PROTECTED]
> > >
> > >
> > > ----- Original Message -----
> > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > > Sent: Monday, February 25, 2002 11:43 AM
> > >
> > >
> > > > We are contemplating moving our application from Unix to NT. The
> main
> > > things
> > > > that concerm me are where our application interfaces with the OS,
> via
> > a
> > > C
> > > > external procedure, and also via UTL_FILE. Also, can I expect
> DBMS_JOB
> > to
> > > > work OK?
> > > >
> > > > Anyone got experience of porting this sort of functionality to NT?
> > > >
> > > > John
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > --
> > > > Author: John Dunn
> > > > INET: [EMAIL PROTECTED]
> > > >
> > > > Fat City Network Services -- (858) 538-5051 FAX: (858)
538-5051
> > > > San Diego, California -- Public Internet access / Mailing
> Lists
> > > >
--------------------------------------------------------------------
> > > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
in
> > > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > > (or the name of mailing list you want to be removed from). You
may
> > > > also send the HELP command for other information (like
subscribing).
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Igor Neyman
> > > INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing
Lists
> > > --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author:
> > > INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing
Lists
> > > --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Igor Neyman
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> >
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Igor Neyman
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
