Jared It would be useful if you could point me in the right direction.
I guess the real question for me is will UTL_FILE work properly when I move to NT, including on Network drives?. There seems to be some doubt amongst the listers as to whether it does. John. > -----Original Message----- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: 27 February 2002 18:35 > To: Multiple recipients of list ORACLE-L > Subject: RE: moving from unix to NT > > 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). -- 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).
