Unanswered: Copying table that contains a LONG RAW column
Does anyone know if it is possible to copy a table containing a LONG RAW column into another table? If so, do you have an example of how to do so? I tried this using a cursor and received the following error:
2> DECLARE CURSOR datacursor IS SELECT LETTER_IMAGE_ID, LETTER_IMAGE FROM LETTER_IMAGE;
3> datarecord datacursor%ROWTYPE;
5> OPEN datacursor;
7> FETCH datacursor INTO datarecord;
8> EXIT WHEN (datacursor%NOTFOUND);
9> INSERT INTO "Tmp_LETTER_IMAGE"(LETTER_IMAGE_ID, LETTER_IMAGE) VALUES (datarecord.LETTER_IMAGE_ID, datarecord.LETTER_IMAGE);
10> END LOOP;
ORA-01400: cannot insert NULL into ("NF_TEST2"."Tmp_LETTER_IMAGE"."LETTER_IMAGE")
ORA-06512: at line 9
There are no nulls in the letter_image(LONG RAW) column.
Any help is appeciated. Thanks.