Re: Here is how to transform "DADD2PBA" to "DA2PPB"

From: Tommy Wareing <p0070621_at_brookes.ac.uk>
Date: Wed, 28 Oct 1998 16:55:07 GMT
Message-ID: <36374bc4.19285811@news.brookes.ac.uk>

On Wed, 28 Oct 1998 16:44:20 GMT, clbeck_at_us.oracle.com (Christopher Beck) wrote:

>On Wed, 28 Oct 1998 12:55:22 GMT, p0070621_at_brookes.ac.uk (Tommy
>Wareing) wrote:
>
>
>>
>>
>>This is the thing that makes me cringe most about PL/SQL: the need to
>>declare temporary strings with a maximum size: in this case 2000
>>characters. I know this seems large enough for all practical purposes
>>(and probably is), but Oracle 8 allows the limit to go up to 4000
>>characters, which could result in this code producing a VALUE_ERROR
>>exception, which is always embarrasing.
>
>In PL/SQL you can declare varchars of length up to 32K in both Oracle7
>and Oracle8.

Mea Culpa. I've just checked in my manual, and you're right (But considering your email address, you ought to be, really. :-)

The 2000/4000 character limit is in database columns, not PL/SQL variables.

Ah. It's that consistancy thing again :-) --
Tommy Wareing
MIS Group
Learning Resources
Oxford Brookes University
01865 483389 Received on Wed Oct 28 1998 - 10:55:07 CST