well,

thanks for those of you gave me the hints, and i m sorry i m posting a bit here on this!

i did found out the cause of the error, which was that 'ls_message_body2' is of type LONG, and it was getting populated in a loop, with each record putting its data into the variable. and well, the limit of LONG is 32760 in PL/SQL. so because of much data the max limit was getting reached.

for now, i have put a bux fix and later i m thinking of using a CLOB.