Re: Can print to file in PL/SQL?

Why can't you just turn the spooler on give it a filename and then spool off. use the putline ect.

Sorry if this is a dumb comment.

Craig Harper

clbeck_at_us.oracle.com (Christopher L. Beck) wrote:
>jarchie_at_ivar7 (Jennifer L. Archie) wrote:
>>
>>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,
>
>I have to apologize for the answer I gave you. I have been working
>with forms 4.5 too long now. The text_io package is part of forms :-(
>
>not the dbms, yet. Oracle 7.3 will allow you to write to the file
>system.
>
>Sorry for the confusion.
>
>chris.
>--
>clbeck_at_us.oracle.com
>Oracle Government
>
Received on Thu Sep 14 1995 - 00:00:00 CEST