Shan.

The datatype of the field is varchar2(1024) and the data is inserted through java codes/J2EE applications. Infact this field stores the XML parameters in it and as such contains carriage returns in it. These carriage returns get created while entering the xml parameters in the text area of the web page which is used to enter data to this field. We can't enter these xml parameters all in one line (without carriage returns) while entering data through the web page as that wont be acceptable to the xml developers who will use the data later.

thanks

Parijat