Re: Varchar usage
Date: 2000/01/29
Message-ID: <86tdr9$b6o$1_at_news08.btx.dtag.de>#1/1
Hello,
the maximum length of varchar2 is 2000 bytes, longer text will be rejected.
Use LONG instead :
LONG
You use the LONG datatype to store variable-length character strings. The
LONG datatype is like the VARCHAR2 datatype, except that the maximum length
of a LONG value is 32760 bytes.
You can insert any LONG value into a LONG database column because the
maximum width of a LONG column is 2147483647 bytes. However, you cannot
select a value longer than 32760 bytes from a LONG column into a LONG
variable.
LONG columns can store text, arrays of characters, or even short documents. You can reference LONG columns in UPDATE, INSERT, and (most) SELECT statements, but not in expressions, SQL function calls, or certain SQL clauses such as WHERE, GROUP BY, and CONNECT BY. For more information, see Oracle7 Server SQL Reference.
Hope that helps ...
Ya Li Wang <ylwang_at_smi.stanford.edu> schrieb in im Newsbeitrag:
Pine.GSO.4.05.10001281556120.28642-100000_at_taiyang...
> always got rejected for the reason of field length exceeds the maximium
> length.
>
> Error message:
>
> ----------
> Record 81: Rejected - Error on table LOADTEST0, column VALUE1.
> Field in data file exceeds maximum length
> ----------
>
Received on Sat Jan 29 2000 - 00:00:00 CET