VARCHAR2 Length
From: The Magnet <art_at_unsu.com>
Date: Wed, 9 Dec 2009 08:24:49 -0800 (PST)
Message-ID: <8f33e57c-a208-4cf0-9147-7e215dc51ab5_at_a21g2000yqc.googlegroups.com>
Date: Wed, 9 Dec 2009 08:24:49 -0800 (PST)
Message-ID: <8f33e57c-a208-4cf0-9147-7e215dc51ab5_at_a21g2000yqc.googlegroups.com>
So, the max length of VARCHAR2 is 4000 bytes. So, in PL/SQL, if you need to declare a variable longer than 4000, what can you use? We need to declare a variable and continue to concatenate strings onto it and it becomes longer than 4000 bytes, so, we're SOL?
Still looking for the answer on other sites. Received on Wed Dec 09 2009 - 10:24:49 CST