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

As far as I know, with the UTL_FILE package you can write and read files on the server.

If you want to write files on the client, it depends on which tool you use. So which one do you use?

In Forms use the TEXT_IO package, in SQL*Plus spool some file and use DBMS_OUTPUT. Eddy.

Urmila & Hazi Mistry wrote:

> 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 Wed Dec 23 1998 - 02:42:13 CET