Re: utl_file.fopen on NT

Hello Helen,

 Check the length of your string. You cannot go over 1023 bytes (which means even less characters in some languages!). I had to fight with this for Chinese and Japanese before I realised what the problem was.

 Hope this helps,
 P

helen.yates_at_compaq.com wrote:
>
> I have set the pfile variable UTL_FILE_DIR = *
>
> I'm trying to use fopen for read on a file which exists and I keep getting
> invalid_operation exceptions. I've tried moving the file to the server, the
> client and still no go. The stored procedure contains:
>
> v_file utl_file.file_type; ... v_file :=
> sys.utl_file.fopen('F:\Helen\','Ccgt0106.eft','R'); EXCEPTION WHEN
> utl_file.invalid_path THEN dbms_output.put_line('Invalid location'); WHEN
> utl_file.invalid_mode THEN dbms_output.put_line('Invalid mode'); WHEN
> utl_file.invalid_operation THEN dbms_output.put_line('Invalid operation');
>
> and this produces:
>
> Invalid operation
>
> F drive is on the server and the code is in a stored procedure being executed
> at the client. Are there any tips for using stored procedures containing
> utl_file commands from a client?
>
> Thanks, Helen
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Tue Jun 02 1998 - 16:08:14 CDT