Xref: alice comp.databases.oracle.tools:40629
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!colt.net!news-x.support.nl!bullseye.news.demon.net!demon!news.demon.nl!demon!sybrandb.demon.nl!not-for-mail
From: "Sybrand Bakker" <postbus@sybrandb.demon.nl>
Newsgroups: comp.databases.oracle.tools
Subject: Re: How to use UTL_FILE.FOPEN()
Date: Fri, 3 Mar 2000 22:31:45 +0100
Message-ID: <952119344.29605.1.pluto.d4ee154e@news.demon.nl>
References: <1caf4cbd.a75d1091@usw-ex0104-033.remarq.com>
X-Trace: news.demon.nl 952119344 pluto:29605 NO-IDENT sybrandb.demon.nl:212.238.21.78
X-Complaints-To: abuse@nl.demon.net
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211
Lines: 34


garych <garychNOgaSPAM@unidial.com.invalid> wrote in message
news:1caf4cbd.a75d1091@usw-ex0104-033.remarq.com...
> I am trying to use UIL_FILE.FOPEN(location, filename, openmode).
> It keep giving me error. The menu said that this function can be
> used for server side or client. If I just write a PL/SQL code on
> my client machine with SQL*PLUS using this function. Is
> the 'location' client side location or server side location.
> How can tell this function will server side file or client side
> file?
> My code like this:
> UTL_FILE.FOPEN('c:\\input', 'infile.txt', 'r')
>
> It give me error like 'invalid path'.
>
> Any help will be appreciated?
>
> G. Chen
>
>
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>

Server side, PL/SQL in sql*plus runs on the server.

Hth,

Sybrand Bakker, Oracle DBA