Re: FORALL Insert error into ORA-00947 - Too many values...

On 27 Mar 2006 13:57:23 -0800, "Raman" <raman.jathar_at_gmail.com> wrote:

>I am using this code to transfer data from 1 table to another. Tables
>used in this script are juts test tables to test the concept.
>Iam not sure whats the problem.
>I am using FOR ALL for teh first time.

table has 2 columns, your insert has 1. This would have gone wrong in an ordinary insert too.
Question: you didn't look up the error message prior to posting, did you? Please change this habit.

--
Sybrand Bakker, Senior Oracle DBA