Re: file text

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Wed, 23 Aug 2000 10:53:23 +0200
Message-ID: <8o03gl$6lv$1_at_s1.read.news.oleane.net>

Could you add an exception block to your proc, somthing like:
...
exception

   when utl_file.invalid_path then

      dbms_output.put_line('>>> Invalid path');    when utl_file.invalid_filehandle then

      dbms_output.put_line('>>> Invalid file handle');    when utl_file.invalid_mode then

      dbms_output.put_line('>>> Invalid mode');    when utl_file.invalid_operation then

      dbms_output.put_line('>>> Invalid operation');    when utl_file.write_error then

      dbms_output.put_line('>>> Write error');
   when utl_file.read_error then
      dbms_output.put_line('>>> Read error');
   when utl_file.internal_error then
      dbms_output.put_line('>>> Internal error');
   when others then
      dbms_output.put_line('>>> Other error : '||sqlerrm);

end;
/
and post us the error message.
(don't forget the "set serveroutput on size 10000" before executing the proc)

--
Regards
Michel


Sandy <daleelaNOdaSPAM_at_usa.net.invalid> a écrit dans le message :
0a0bc822.f05d8c59_at_usw-ex0110-076.remarq.com...


> Hi,

>

> Sorry to bother you again but I did all you said and it 's


> still doesn't want to work . I still have the ORA-06510 :

> exception définie par l'utilisateur non traitée.

> The oracle database is started by the system account : so I

> suppose if my directory is in in partition under NTFS I

> have to give these rights to the system user of NT and if

> it under FAT I have to do nothing about this ..?

> My procedure which creates the file can be under any schema

> which can execute the UTL_FILE package ?

> I don't think there is any problem of case sensitive under

> NT, but I put the name of directory in caps in my procedure

> and in the init.ora.

>

> IF you have any idea about why it doesn't work , please

> tell me

>

>

> thanks very very much

>

> 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

Received on Wed Aug 23 2000 - 10:53:23 CEST