I have problem with copy rows with blob from one table to another. First I used cursor to fetch rows with 4 columns needed to file, next i copy this rows to another table using insert. Everything is copied, but problem is only with blob column, because column is copied but when I checked using dbms_lob.getlength("BLOB") in original table i have value but in second table I have 0. I copy this column like another, maybe is different way to copy blob column?
Any idea what can be a problem ?