LONG RAW to CLOB conversion --- LONG RAW exceeding 32K SIZE for some col.
454631Oct 18 2005 — edited Mar 5 2012Hi,
My source data contains a char data in LONG RAW column. I have to convert it to Char(CLOB). The problem is that i can not access the LONG RAW data for some columns for which the size exceeding above 32k. I have wriiten the function using DBMS_SQL package to retrieve only 32K LONG RAW data & then i am converting it to char(CLOB). But as the LONG RAW size is exceeding for some columns, i want to retrieve the data upto 64K insted of 32 K.
I am using the SP to retieve the data from LONGRAW.
Is it possible to retrive whole data if instead of LONG RAW, the column data type is BLOB
Its very urgent
Thx in advance!
Shilpa