How can I write on a file?

From: Pepe Galindo <ppgg_at_lcc.uma.es>
Date: 1997/09/08
Message-ID: <Pine.GSO.3.96.970908103350.7342B-100000@sol10>#1/1

hello!

Why do not write the following PL/SQL program?

---

DECLARE
  CURSOR query IS SELECT atributo FROM TABLA;   fich UTL_FILE.FILE_TYPE;

BEGIN
  fich:=UTL_FILE.FOPEN('users','pprueba.sql','w');   FOR item IN query LOOP

      UTL_FILE.PUT_LINE(fich,item.atributo);   END LOOP;
  UTL_FILE.FCLOSE(fich);
END;
/

---

Error message:
ORA-06510: PL/SQL: unhandled user-defined exception. ORA-06512: at "SYS.UTL_FILE", lines 82 and 120.

I work in a PC with Personal Oracle. Thanks!

ppgg_at_lcc.uma.es Received on Mon Sep 08 1997 - 00:00:00 CDT