Re: Can print to file in PL/SQL?

Christopher L. Beck (clbeck_at_us.oracle.com) wrote:

: declare
: file_ptr text_io.file_type;
: begin
: file_ptr := text_io.fopen( 'FILE_NAME', 'W' );
: text_io.put_line( file_ptr, 'ONE LINE OF THE FILE' );
: text_io.put_line( file_ptr, 'ANOTHER LINE OF THE FILE' );
: text_io.fclose( file_ptr );
: end;

Thanks Chris,

That's exactly what I would like to do. But ...

It appears that we do not have the TEXT_IO package in our db; by the way, we're using Oracle7 v7.1.4.1.0 and PL/SQL 2.1.4.0.0. I looked at the /rdbms/admin sql scripts and couldn't locate anything about text_io, file_type or fopen/fclose. Is that a special package? How can I obtain it?

Thanks for the pointers.
jennifer