Combining multiple blob rows into one row and insert the results into separate table. ERROR: "column
I have a table(filename Varchar2, File_SEQ INT, File_Data(blob)).
The data is stored in the table below.
File Name a , 0, BLOB
File Name a, 1, BLOB
File Name a, 2, BLOB
What to Achieve: merge/append 3 rows into 1 and insert them as a single row for a file. I was able to append 3 records into 1 by using DBMS_LOB. Append procedure. (dbms_lob.append(v_blob,temp_data)) . Also, I can see the correct length of the final Blob value by using. dbms_lob.get length(v_blob) .
Problem: When I try to insert the v_blob into a table, I'm getting an error 00984. 00000 - "column not allowed here"