SQL & PL/SQL

Hi,

I Have Four Fields (Remarks1,Remarks2,Remarks3,Remarks4) data type varchar2(4000) of each field, I want to convert the data of these fields to blob and stor it in one sinle blob data type fields:

For this I have created one more field (Remarks) in my table with data type bolb:

I use "Utl_raw.cast_to_raw: to achieve this, but unable to succeeded;

when I try to update the data of these four fields to one blob field I get the following error:

ORA-06502: PL/SQL numeric or Value Error: raw variable length too long
ORA-06512: at "SYS.UTL_RAW" , line 224.

What should I do to resolve this.

Regards,
*Raza*

Edited by: Khan2 on May 24, 2011 4:45 PM