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: Help!!! LONG database field is truncated

Re: Help!!! LONG database field is truncated

From: Daniel <delj_at_flash.net>
Date: Tue, 18 Jan 2000 20:42:46 GMT
Message-ID: <af4h4.4975$V84.207975@news.flash.net>


In SQL*Plus, pull down the Options menu and select Environment. Scroll down to Long and LongChunckSize. The default is 80.

Daniel
Austin, TX

"Ludo" <llenglet_at_pagenet.fr> wrote in message news:862a4m$ueh$1_at_news.x-echo.com...
> An Oracle database has a LONG database field. When i make an insert in a
> database with SQL Plus, a string which has more than 80 characters is t
> runcated.
>
> I would like to know how to configure Oracle to take correctly into acco
> unt database fields > 80 characters ?
>
> Thanks a lot.
>
>
> Ludo
>
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> Article poste via Voila News - http://www.news.voila.fr
> Le : Tue Jan 18 19:07:18 2000 depuis l'IP : 195.115.154.253
Received on Tue Jan 18 2000 - 14:42:46 CST

Original text of this message

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