How to update a CLOB?
Hello!I got a database with a clob.
The database is initated with oracale "load data" and LOBFILE('PATH_TO_A_FILE').
I now need to update a certaion row in this table with a new CLOB.
I got some foregin keys to this row so I can not delete an reinsert it.
Is this possible to update the clob in some way?
I tried like:
UPDATE the_table set clob_column LOBFILE('PATH_TO_A_FILE') where id = 1;
But it does not work.
Any ideas is most welcome.
Best regards
Fredrik