Re: UTL_FILE access

From: Laurie Kirsh <lkirsh_at_itsc.org>
Date: 1997/08/18
Message-ID: <01bcac18$4a8739e0$2d2bb1cc@Kirsh.itsc.state.md.us>#1/1

Some tips for you:
If you are using UTL_FILE on NT4.0, I ran into a couple of problems that ARE NOT fixed in any version of 7.3xx or 8. 1. The append mode, contrary to what the book says, does not work. You will get an INVALID_OPERATION error. This is a known bug in Oracle. I found a way to work around it for my specific application but in some cases you are going to be just plain out of luck. 2. It seems that you are unable to open and write to a file across a network. I reported this bug and they still have not fixed it. The person I talked to at Oracle claimed that it is an operating system limitation.

Laurie
"I am always interested in NT specific issues with the Oracle databases...please tell me your war stories"

+-------------------------------------+-----------------------------+
| Laurie J. Kirsh                     | Oracle DBA/Design/Developer |
| lkirsh_at_itsc.org  			  | Integration Systems Analyst |
| Lockheed Martin                     | ITSC project                |
| 301-982-1113				  | College Park, Maryland      |
 +-------------------------------------+-----------------------------+
|Opinions are mine and do not necessarily reflect those of          |
|Lockheed Martin Corporation.                                       |
+-------------------------------------------------------------------+

---

> From: Ari Kaplan <akaplan_at_interaccess.com>
> Newsgroups: comp.databases.oracle.tools; comp.databases.oracle.misc
> Subject: Re: UTL_FILE access
> Date: Friday, August 08, 1997 11:12 AM
>
> Patrick Drouin (patrick.drouin_at_NO_SPAM.nortel.com) wrote:
> : Hello everyone,
> : I'm trying to use the UTL_FILE modules but I can't get them to work.
> : How do I find out which directory are accessible to my packages and how
> : do I had some more if I need to? I'm trying to store some basic output
> : of SQL queries in an HTML file that could be refresh every day.
> : Any help is welcome,
> : Patrick
>
> According to Steve Feuerstein's "PL/SQL Programming" book:
> "The location (of the file) you provide must have been listed as an
> accessible directory in the init.ora file for the database instance.
> When you pass the location as an argument to FOPEN, however, its format
> must differ slightly from the init.ora value."
>
> What that init.ora parameter is, the book does not mention. I tried
> the bdump, cdump, and udump directories, to no avail.
>
> Any suggestions out there?
>
> -Ari Kaplan
> Independent Oracle DBA Consultant
>
> <-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
> <-> For 100+ Oracle tips, visit my Web Page: <->
> <-> <->
> <-> http://homepage.interaccess.com/~akaplan <->
> <-> <->
> <-> email: akaplan_at_interaccess.com <->
> <-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
>
>
 

>
>
Received on Mon Aug 18 1997 - 00:00:00 CDT