Re: How to initialize varchar2 of infinite length

From: Mladen Gogala <>
Date: Tue, 27 Jan 2015 15:21:34 +0000 (UTC)
Message-ID: <>

On Mon, 26 Jan 2015 22:25:22 -0800, wE|rd0 wrote:

> I want to initialize varchar2 of infinite length. But, I read that the
> maximum i can initialize is varchar2(32767).
> varchar2(max) like that in sql server does not work either.
> Any ideas?

VARCHAR2 is not of infinite length and can be at most 4k or 32k, depending on the version. Even CLOB is not infinite, it is at most 2G. There is no such thing as infinity.

Mladen Gogala
The Oracle Whisperer
Je suis Charlie
Received on Tue Jan 27 2015 - 16:21:34 CET

Original text of this message