Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> RE: The use of the UTL_FILE package within PL/SQL [URGENT!!!]

RE: The use of the UTL_FILE package within PL/SQL [URGENT!!!]

From: Urmila & Hazi Mistry <urmila.humsoft_at_force9.co.uk>
Date: Mon, 21 Dec 1998 09:33:56 -0000
Message-ID: <75l4b4$un0$1@news1.force9.net>


I seem to be having problems trying to use the FOPEN function from the UTL_FILE package provided by Oracle 7.3.3 - please help... I have tried the following PL/SQL on my client machine: DECLARE
file_number utl_file.file_type;
BEGIN
file_number := utl_file.fopen('c:\orawin95\bin', 'text.txt', 'w'); END;
And get the following error messages:
DECLARE
*
ERROR at line 1:

ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.UTL_FILE", line 82
ORA-06512: at "SYS.UTL_FILE", line 120
ORA-06512: at line 4

ANY IDEAS???
Urmila Received on Mon Dec 21 1998 - 03:33:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US