Hi,
Is it possible to Convert from BLOB to CLOB?
I am getting following error when trying to update:
ORA-00932: inconsistent datatypes: expected CLOB got BLOB
When I am trying to ALTER table to MODIFY BLOB to COLB getting:
ORA-22858: invalid alteration of datatype
We are storing Resume in BLOB but to crawl with Google we need to put resume col in CLOB. Is it anyway I can change data type and copy data over to new column for CLOB?

Thanks, 
]

Thanks.I am not sure,  I have to talk with my developer but anyway it's possible? Or If Googl can crawl then what?
As I have information is: when Google crawls the BLOB column it converts the data into binary data type and the field becomes not searchable. If we create new column into CLOB format, when Google will crawl the column it would convert it to plain text and this column will be searchable by Key Words from Google

thanks,