From: Wilhelm Stiefelhagen <Wilhelm.Stiefelhagen@t-online.de>
Newsgroups: comp.databases.oracle.misc
Subject: Re: 8i Personal Edition limitations?
Date: Sat, 09 Sep 2000 23:41:43 +0200
Organization: T-Online
Lines: 38
Message-ID: <39BAAE96.F49F1087@t-online.de>
References: <8our5r$8um$1@plutonium.btinternet.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: news.t-online.com 968535411 13 23549 320055822712-0001 000909 21:36:51
X-Complaints-To: abuse@t-online.de
X-Sender: 320055822712-0001@t-dialin.net
X-Mailer: Mozilla 4.75 [en]C-CCK-MCD DT  (WinNT; U)
X-Accept-Language: en


Gary wrote:

> Does the Personal Edition limit CLOBs to 4000 chars? I can't insert any data

You suffer from limitations which exist also in the full version.

Literals are limited to 4000 char.
If you write a PLSQL procedure, you can handle longer strings with varchar2,
up to 32 k. (Literals are still 4000 max, but you may concatenate them.).

To handle larger sizes, you need one of teh DBMS... extensions.

>
> via SQL*Plus or ODBC/ASP that's larger than 4000 chars without getting a
> "string literal too long" error message. At first I thought it was an ODBC
> problem, then a problem with my appplication server, but since SQL*Plus is
> telling me the same thing I'm wondering if it's a limitation or even if I'm

Yes, it is a limitation of SQL*Plus.

>
> missing some secret of how to work with CLOBs! ;-)
>

Same problem with long fields.

>
> While I'm here, I'm also wondering if another limitation is the inability to
> connect to anything but the local database? I've searched technet.oracle.com
> for known limitations but that's drawn a blank.
>
> Gary.

Willi

wilhelm.stiefelhagen@gmx.net