Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: UTL_FILE problem

Re: UTL_FILE problem

From: Bob <meyer_b_at_my-deja.com>
Date: Mon, 06 Sep 1999 17:25:18 GMT
Message-ID: <7r0tdi$v58$1@nnrp1.deja.com>


Stephen:

Thanks. I do have UTL_FILE_DIR set in init.ora. I tried writing to ORANT\BIN and ORANT\DATABASE, which I would think ORACLE had write priviledges to, but maybe not.

How do I grant this priviledge. I'm looking at the NT user manager, and I can add oracle as a user, of course. But what do I specify for a password?

Thanks again,

Bob

In article <7qv3ei$npr$1_at_nnrp1.deja.com>,   broeni_at_my-deja.com wrote:
> please refer to
> http://x45.deja.com/[ST_rn=ap,ST_Tracker=0508]/getdoc.xp?
> AN=521191496&CONTEXT=936579235.297599161&hitnum=0
> that lists 2 pitfalls I had to solve for using UTL_FILE.
>
> regards, Stephan
>
> In article <7qu8hn$5vo$1_at_nnrp1.deja.com>,
> Bob <meyer_b_at_my-deja.com> wrote:
> > Hi all:
> >
> > I'm trying to use UTL_FILE (for the first time ever), to write a
file
> on
> > an NT Server. Whenever I try to run it, I get a
UTL_FILE.INVALID_PATH
> > exception.
> >
> > I've modified initorcl.ora to include UTL_FILE_DIR = * (for
> > testing--initially I had it limited to one specific directory) and
> I've
> > stopped and restarted ORCL. Actually, I've rebooted the server just
> to
> > be sure. I'm running the script on on the server, too.
> >
> > Here's my code:
> >
> > DECLARE
> > v_filename VARCHAR2(12) := 'TEST.MAIL';
> > v_file_loc VARCHAR2(40) := 'C:\';
> > v_file_mode VARCHAR2(1) := 'A';
> > v_file_handle UTL_FILE.FILE_TYPE;
> >
> > BEGIN
> > v_file_handle := UTL_FILE.FOPEN (v_file_loc,
> > v_filename,
> > v_file_mode);
> >
> > (I've also tried directories other than the root.) Does anyone have
> any
> > clues about what I might be doing wrong?
> >
> > Thank, very much, in advance.
> >
> > Bob
> > --
> > Bob M.
> >
> > Step outside. The graphics are AMAZING!
> >
> > Sent via Deja.com http://www.deja.com/
> > Share what you know. Learn what you don't.
> >
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

--
Bob M.

Step outside. The graphics are AMAZING!

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Sep 06 1999 - 12:25:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US