Re: Help! Writing to a list file

Oops 2.1? I can't remember for sure, but I think support for UTL_FILE didn't come until about version 2.3 (Oracle 7.3.4).

--
Jim Harrison
Colway Software and Design
www.colway.net

Jim Harrison <jim_at_colway.freeserve.co.uk> wrote in message
news:8irei6$rrn$1_at_news5.svr.pol.co.uk...


> If your output is less than 1Mb, the easiest way is to use:


>  dmbs_output.put_line('text');

> don't forget to use set serveroutput on size(1000000) at the start of your

> session.

> Failing that you can use UTL_FILE.  Takes a bit more to set-up, but is far

> more flexible.

>

> --

> Jim Harrison

> Colway Software and Design

> www.colway.net

>

> Evelyn Chepkonga <evelyn.chepkonga_at_memo.ikea.com> wrote in message

> news:8irbbo$cja$1_at_mailgate.ikea.com...

> > Hi folks,

> > I am trying to write to a list file from a stored procedure using PL\SQL

> > version 2.1. Anyone have any suggestions?

> >

> > thanks,

> > Evelyn Chepkong'a

> >

> >

>

>