Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Pb using UTL_FILE

Re: Pb using UTL_FILE

From: Huiming Lee <huiming_at_pop21.odn.ne.jp>
Date: Fri, 11 Feb 2000 00:37:59 +0900
Message-ID: <38A2DB57.4DEC36ED@pop21.odn.ne.jp>


No, it will not work either.
I encountered the same problem only 2 days ago. You can not exceed 1023bytes with put and put_line according to oracle document.
Maybe you should try external procedures using .dll.

Tom Zamani wrote:
>
> Why don't you write the line in two sections.
> eg
> utl_file.put('512 chars');
> utl_file.put('512 chars');
> utl_file.put(chr(13));
> or something like that
>
> <bagnouls_at_hotmail.com> wrote in message news:87n0d3$ske$1_at_nnrp1.deja.com...
> > Hi,
> >
> > I need to write a unique line that contains more than 1024 characters
> > into a file. The functions PUT_LINE or PUT raise an exception when I try
> > to do this.
> >
> > Does anyone have a solution for that problem ?
> >
> > Cyril (I'd rather have a answer by EMAIL please, thanks a lot)
> > bagnouls_at_hotmail.com
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
Received on Thu Feb 10 2000 - 09:37:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US