ora-6510 ora-6512 ora-1403 errors

[DaPi]

Originally posted by DaPi
What's wrong with something like:

Insert Into table_B
SELECT REQUEST_ID, etc, etc
FROM table_A
WHERE
ACTUAL_COMPLETION_DATE <= SYSDATE
AND STATUS_CODE = 'C'
AND PHASE_CODE = 'C'
AND PRINTER != 'noprint'
AND NUMBER_OF_COPIES > 0
and not exists
(Select * From table_B
where table_B.request_id = table_A.request_id)
;