Oracle Database Discussions

Hi All,

i am getting one issue for a column in table which is having RAW data type and it contains hexadecimal values for that column. I want to retrieve the data in readable format as that column is having attachment files data(Huge data).i have used utl_raw.cast_to_varchar2(attachment)  but its also giving data of 2000 characters(Oracle SQL Property) of that attachment file,not fully file data.

Please suggest me the solution.Help here pls.

Table Structure:--

TESTMETA_TASK_AUDIT_ATT;

Name                           Null     Type                                                                                                                                                                                        

------------------------------ -------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

GUID                           NOT NULL NVARCHAR2(32)                                                                                                                                                                               

IDX                            NOT NULL NUMBER                                                                                                                                                                                      

ATTACHMENT                     NOT NULL RAW(2000)

Thanks for your help.