PL/SQL (MOSC)

MOSC Banner

Combining multiple blob rows into one row and insert the results into separate table. ERROR: "column

in PL/SQL (MOSC) 8 commentsAnswered

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"

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center