Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Posts
    7

    Unanswered: Copying table that contains a LONG RAW column

    Hello.

    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;
    4> BEGIN
    5> OPEN datacursor;
    6> LOOP
    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;
    11> END;
    12> /
    ORA-01400: cannot insert NULL into ("NF_TEST2"."Tmp_LETTER_IMAGE"."LETTER_IMAGE")
    ORA-06512: at line 9
    SQLWKS>

    There are no nulls in the letter_image(LONG RAW) column.
    Any help is appeciated. Thanks.

  2. #2
    Join Date
    Apr 2001
    Location
    Netherlands
    Posts
    191
    I think you can use the COPY sql command to do it.
    Ruud Schilders
    -----------------
    Oracle DBA
    e-mail : ruud@schilders.it
    URL : www.schilders.it
    Twitter : www.twitter.com/ruudschilders

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •