Re: Large text strings and CLOBS

Yes. I have same feelings.

Now I have a project to insert large string into CLOB column. These strings in a text file, one string one line, each has more than 4000 characters. I tried to use UTL_FILE package to read them. But UTL_FILE.GET_LINE can not read more than 1022 characters. So not to say inserting into CLOB. If anyone has a new way to do it, please pass me a hand. Thanks in advance.

Weiming He

Andy Marden wrote:
>
> Does anyone know if there has been a special prize going round
> internally in Oracle for the last few years to devise the most bizarre,
> complex and restrictive ways of dealing with large text strings in the
> RDBMS and toolset?
>
> We have VARCHAR2 which inexplicably has different size limitations in
> PL/SQL and the RDBMS (oh, thanks for the increase to 4000 in Oracle8,
> very generous).
>
> We have LONG which is 2Gb in the RDBMS, 32K-ish in PL/SQL and
> unsupported in SQL*Plus; and are virtually impossible to use in any
> sensible way.
>
> We have VARCHAR2S developed for the DBMS_SQL package, allowing > 32K SQL
> to be parsed.
>
> Now we have CLOB which have their own limited access packages, have to
> be stored in a table, etc. and must always be treated specially.
>
> Why, on earth, can't we just have VARCHAR2 of user-definable max length
> (init.ora let's say), all manipulated through standard functions
> (SUBSTR, REPLACE, etc), with fancy packages to chop them up for
> efficient processing in client-server environments as an option.
>
> Does life REALLY have to be made this difficult?
>
> Andy
Received on Mon Jul 12 1999 - 19:11:37 CDT