RE: problem with UTL_FILE.FILE OPEN

2001-03-15 Thread Dasko, Dan
Cool, you learn something new everyday. Dan -Original Message- Sent: Wednesday, March 14, 2001 8:05 PM To: Multiple recipients of list ORACLE-L Dan - I've previously used the * to define utl_file_dir with no problems. According to the documentation: "The parameter specification

RE: problem with UTL_FILE.FILE OPEN

2001-03-15 Thread Connor McDonald
utl_file_dir = * is VERY bad news... for i in ( select file_name from dba_data_files ) loop open file i.file_name for write end loop; and voila...No more db --- "Dasko, Dan" [EMAIL PROTECTED] wrote: Cool, you learn something new everyday. Dan -Original Message- Sent:

Re: problem with UTL_FILE.FILE OPEN

2001-03-15 Thread David A. Barbour
Connor - Fortunately, that requires dba privs which (see previous posts from Rachael, Lisa, et al) your folks don't have. Right? Actually though, you make a good point - there is some risk involved in setting the parameter to *. The files are created/written as the oracle user, so any

RE: problem with UTL_FILE.FILE OPEN

2001-03-14 Thread Dasko, Dan
I thought that a directory had to be specified by name in initora. I don't think you can specify a wildcard or a higher level directory. I could be wrong. Dan -Original Message- Sent: Wednesday, March 14, 2001 5:16 AM To: Multiple recipients of list ORACLE-L List hi! Oracle817 on

Re: problem with UTL_FILE.FILE OPEN

2001-03-14 Thread Shankar Shanmugaswamy
Hi, Eventhough you have given the path as * in initora Make sure that the path where you are creating the file is access to the Unix User , who is running the script The unix user should have the access Read , Write and Execute But the User thur which Oracle is Installed will be able to run

RE: problem with UTL_FILE.FILE OPEN

2001-03-14 Thread Gogala, Mladen
You're supposed to set the parameter to a directoryname, not an asterisk. Setting the parameter to something like /oracle/base/8.1.7/work and setting the protection of the directory to 0644 (files are written by the oracle server processes) should help. -Original Message-

RE: problem with UTL_FILE.FILE OPEN

2001-03-14 Thread Gogala, Mladen
Of course, with 8.1.7 you can implement your own UTL_FILE package, using external calls to C routines. -Original Message- Sent: Wednesday, March 14, 2001 5:16 AM To: Multiple recipients of list ORACLE-L List hi! Oracle817 on AIX. (64 bit) We have defined in initora file UTL_FILE_DIR=*

RE: problem with UTL_FILE.FILE OPEN

2001-03-14 Thread Anderson, Brian
, 2001 10:07 AM To: Multiple recipients of list ORACLE-L Subject: RE: problem with UTL_FILE.FILE OPEN I thought that a directory had to be specified by name in initora. I don't think you can specify a wildcard or a higher level directory. I could be wrong. Dan -Original Message

RE: problem with UTL_FILE.FILE OPEN

2001-03-14 Thread Guidry, Chris
of list ORACLE-L Subject: RE: problem with UTL_FILE.FILE OPEN You're supposed to set the parameter to a directoryname, not an asterisk. Setting the parameter to something like /oracle/base/8.1.7/work and setting the protection of the directory to 0644 (files are written

RE: problem with UTL_FILE.FILE OPEN

2001-03-14 Thread Kathy Duret
To: Multiple recipients of list ORACLE-L Subject: RE: problem with UTL_FILE.FILE OPEN I thought that a directory had to be specified by name in initora. I don't think you can specify a wildcard or a higher level directory. I could be wrong. Dan -Original Message- Sent

Re: problem with UTL_FILE.FILE OPEN

2001-03-14 Thread David A. Barbour
Dan - I've previously used the * to define utl_file_dir with no problems. According to the documentation: "The parameter specification UTL_FILE_DIR = * has a special meaning. This entry turns off directory access checking, and it makes any directory accessible to the UTL_FILE functions." I'm