If the database varchar2 column is 4k. In PL/SQL, you can define a varchar2 variable up to 32K. Note that if you want to insert this variable into a database column you have to trim it to 4k.

[Edited by kris109 on 03-05-2002 at 02:43 PM]