Re: 8i Personal Edition limitations?

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_at_gmx.net Received on Sat Sep 09 2000 - 16:41:43 CDT