UTL_FILE use in Anonymous PL/SQL Block

From: <pmohanan_at_my-deja.com>
Date: 2000/08/03
Message-ID: <8mc91u$2aq$1_at_nnrp1.deja.com>#1/1


[Quoted] hi..All,

    I have an anonymous PL/SQL block. I am trying to open a file to write data. But at the stmt

UTL_FILE.FOPEN(o_dir,o_file,'w') generates an user-defined exception. I have set the variable UTL_FILE_DIR also.

IS is not possible to use this package in an anonymous PL/SQL Block?

Regards,

Praveen

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Aug 03 2000 - 00:00:00 CEST

Original text of this message