Re: Can print to file in PL/SQL?
Date: 1995/09/15
Message-ID: <43c3ok$rje_at_maverick.tad.eds.com>#1/1
In article <DEv7rI.2L9_at_da_vinci.ecte.uswc.uswest.com>, jarchie_at_ivar7
says...
:
: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
:
:****
:Jennifer L. Archie
:U S WEST Technologies
:E-mail: jarchie_at_lookout.ecte.uswc.uswest.com
It's a built-in package shipped with Oracle Procedure Builder.
Mike Received on Fri Sep 15 1995 - 00:00:00 CEST