Hi Karthik

Maximum length for varchar2 variable can be 32767.
So, IMHO, datatype should not be your problem.


Hope that helps
All the best

Ajay


-----Original Message-----
From: Dhanya
[mailto:oracledba-ezmlmshield-x40131239.[Email address protected]
Sent: Wednesday, August 18, 2004 10:08 AM
To: LazyDBA Discussion
Subject: RE: ORA-06502

hi
for passing large values use LOB
pls try it
dhanya

-----Original Message-----
From: karthikeyan


Oracle LazyDBA home page