-
Hello:
Can anyone tell me how to copy a table with a Long Raw column into another table with the same structure?
I tried a bulk insert and table copy cursor and received the error message below:
SQLWKS> DECLARE
2> CURSOR datacursor IS SELECT LETTER_IMAGE_ID, LETTER_IMAGE, APPLICATION_ID FROM DCP32_MAIN.letter_image WHERE APPLICATION_ID IN (SELECT APPLICATION_ID FROM DCP32_ARCHIVE.credit_application);
3> datarecord datacursor%ROWTYPE;
4> BEGIN
5> OPEN datacursor;
6> LOOP FETCH datacursor INTO datarecord;
7> EXIT WHEN (datacursor%NOTFOUND);
8> INSERT INTO DCP32_ARCHIVE.letter_image(LETTER_IMAGE_ID, LETTER_IMAGE, APPLICATION_ID) VALUES (datarecord.LETTER_IMAGE_ID, datarecord.LETTER_IMAGE, datarecord.APPLICATION_ID);
9> END LOOP;
10> END;
11>
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at line 6
Any help is appreciated.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|