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: ORA-06510 and UTL_FILE package

Re: ORA-06510 and UTL_FILE package

From: Keith Boulton <boulke_at_globalnetnospam.co.uk>
Date: Fri, 25 Sep 1998 11:39:30 GMT
Message-ID: <360b7b85.8646192@news.globalnet.co.uk>


On Thu, 24 Sep 1998 14:07:27 +0200, "Luis Díez" <luis_at_cuende-asociados.es> wrote:

>That is:
>_______________________________________________________
>
>ERROR in line 1:
>ORA-06510: PL/SQL: user-predefined exception not managed
>ORA-06512: in "VITADMIN.MINESET", line 315
>ORA-06512: in line 1
>_______________________________________________________
>
>That line #315 is just
>
> UTL_FILE.PUT_LINE(fout,buffer);
>

I would modify the code to intercept the exceptions defined for utl_file.
Also, I believe the maximum line length for utl_file is 1023 bytes. Received on Fri Sep 25 1998 - 06:39:30 CDT

Original text of this message

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