I sent this on June 21st. Is this a record ;-)
-Original Message-
From: Lord, David - CSG [mailto:[EMAIL PROTECTED]]
Sent: 13 August 2002 22:24
To: Multiple recipients of list ORACLE-L
Subject: RE: Urgent : UTL file problem
Rings a bell. Is the directory/file writable
: RE: Urgent : UTL file problem
Rings a bell. Is the directory/file writable by the ORACLE user?
--
David Lord
-Original Message-
From: Vijaya Chander V.S [mailto:[EMAIL PROTECTED]]
Sent: 21 June 2002 12:58
To: Multiple recipients of list ORACLE-L
Subject: Urgent : UTL
ORACLE-L
Subject: Re: Urgent : UTL file problem
Hi Vijaya
Try adding a when others clause to your code and print out sqlerrm and
get a better idea of what the actual error is. As follows
when others then
dbms_output.put_line(sqlcode||' '||sqlerrm);
raise_application_error(-20001
: UTL file problem
I sent this on June 21st. Is this a record ;-)
-Original Message-
From: Lord, David - CSG [mailto:[EMAIL PROTECTED]]
Sent: 13 August 2002 22:24
To: Multiple recipients of list ORACLE-L
Subject: RE: Urgent : UTL file problem
Rings a bell. Is the directory
Rings a bell. Is the directory/file writable by the ORACLE user?
--
David Lord
-Original Message-
From: Vijaya Chander V.S [mailto:[EMAIL PROTECTED]]
Sent: 21 June 2002 12:58
To: Multiple recipients of list ORACLE-L
Subject: Urgent : UTL file problem
my prog looks like this
Do you miss a / at the end of the path?
/torben
-- Original Message --
Date: Fri, 21 Jun 2002 03:58:19 -0800
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
From: Vijaya Chander V.S [EMAIL PROTECTED]
Subject: Urgent : UTL file problem
my prog looks like
You are getting an unhandled exception so its not the
'invalid_path' error. Code in a handler for the other
possible exceptions which should assist.
hth
connor
--- Vijaya Chander V.S [EMAIL PROTECTED]
wrote: my prog looks like this (utl_file_dir=* is
present
in initSID.ora file):
DECLARE
Do you miss a / at the end of the path?
/torben
-- Original Message --
Date: Fri, 21 Jun 2002 03:58:19 -0800
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
From: Vijaya Chander V.S [EMAIL PROTECTED]
Subject: Urgent : UTL file problem
my prog looks like
Title: RE: Urgent : UTL file problem
vijay,
check the permissions for the /users/vijay directory.
Directories that UTL_FILE can read from and write to must have permissions of the Oracle instance owner and the user running the package.
Also, utl_file_dir=* is not recommended.
Catalin
I think a '/' is missing after vijay.
The documnentation states
"The file location and file name parameters are supplied to the FOPEN
function as separate strings, so that the file location can be checked
against the list of accessible directories as specified in the
initialization file. Together,
You should ALWAYS include the OS in your posts.
I'd look to see if user oracle has write permissions into that folder/directory.
Vijaya Chander V.S wrote:
my prog looks like this (utl_file_dir=* is present in initSID.ora file):
DECLARE
fileHandler UTL_FILE.FILE_TYPE;
BEGIN
can you create a file in /users/vijay as the user oracle? remember oracle is the
writer needs access to do so.
hth,
gene
[EMAIL PROTECTED] 06/21/02 07:58AM
my prog looks like this (utl_file_dir=* is present in initSID.ora file):
DECLARE
fileHandler UTL_FILE.FILE_TYPE;
BEGIN
12 matches
Mail list logo