long to clob column conversion
668402Nov 26 2008 — edited Dec 10 2008Hi
I have a table with a long column,
Now I want to convert it into clob.
I create a new table similar to the original and modified the column to clob and tried to insert the values from the original table using the to_clob function
This is the query I executed
INSERT INTO Table_backup_test1( PROBLEMID, PICTUREOBJ, LASTMODDATE, LASTMODPERSONID) values (SELECT PROBLEMID, TO_CLOB(PICTUREOBJ), LASTMODDATE, LASTMODPERSONID FROM table);
I am getting an err as
ORA-00936: missing expression
..
Please get me the solution as soon as possible if anyone knows ..........
Thanx in adv