Re: Can print to file in PL/SQL?

jarchie_at_ivar7 (Jennifer L. Archie) wrote:

>I would like to print out to a file, the parameter list for a stored
>procedure. Is this possible? I haven't seen any demo examples or read
>anything in the Oracle books that indicate this is possible or not.
>Is there anything I can give to put_line() to tell it to print the buffer
>to a file?
>
>Thanks for the help.
>
>--
>****
>Jennifer L. Archie
>U S WEST Technologies
>PSRP -- Public Service Reengineering Project
>Office: 303-624-4196
>
>E-mail: jarchie_at_lookout.ecte.uswc.uswest.com
>WWW: http://ivarsrv.ecte.uswc.uswest.com/Personnel/jarchie.html

Jennifer try:

declare
  file_ptr text_io.file_type;
begin
  file_ptr := text_io.fopen( 'FILE_NAME', 'W' ); -- 'W' for write or 'R' for read

  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 );

• You now have a two line file called 'FILE_NAME' end;

chris.

--
clbeck_at_us.oracle.com

--
clbeck_at_us.oracle.com
Oracle Government