Re: file text
From: Michel Cadot <micadot_at_netcourrier.com>
Date: Tue, 22 Aug 2000 11:36:30 +0200
Message-ID: <8nthlf$ac8$1_at_s1.read.news.oleane.net>
Date: Tue, 22 Aug 2000 11:36:30 +0200
Message-ID: <8nthlf$ac8$1_at_s1.read.news.oleane.net>
Hello Sandy,
To execute this procedure Alan must have the execute
privilege on the utl_file package.
Then, you have to add a parameter to your init.ora file:
utl_file_dir='c:\test' (and bounce the database).
Finally, as this is the rdbms server that writes into the
file, oracle must have the read/write privilege on the directory.
Alan and others users need no right on this directory.
-- Have a nice day Michel Sandy <daleelaNOdaSPAM_at_usa.net.invalid> a écrit dans le message : 1cca3b29.ffa6044e_at_usw-ex0110-076.remarq.com...Received on Tue Aug 22 2000 - 11:36:30 CEST
> Hi,
>
> Yes I am trying to use the utl_file I found when i searched
> for the text_io package. They were saying in the book that
> the text_io is for the client side and I need something in
> the server side .
> I am trying with a small example :
>
> ------------
> procedure test
> is
>
> v_outputfile UTL_FILE.FILE_TYPE;
>
> begin
>
> v_outputfile:=UTL_FILE.FOpen('c:\test\','toto.txt','a');
> UTL_FILE.PUTF(v_outputFile,'coucou');
> UTL_FILE.FCLOSE(v_outputFile);
>
> end;
>
> -----------
> This procedure is created under the schema "Alan". When I
> execute this procedure when i am connected under Alan, it
> doesn't work. I suppose I must give him permissions, but
> which ones ?
> Maybe it is kinda dangerous because i will put this on the
> web and each user connected will have rights to write on
> this directory. What do you think ?
>
>
> Thanks a lot
>
>
> SAndy
>
>
>
>
> * Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images,
Audios, Videos, News, and Shopping. Smart is Beautiful