Table structure for the execute immediate

[kondakindi]

table structure is of report1 is
app_name varchar2(10),
name varchar2(10),
insert_date date,
session_id varchar2(50),
seq_num number,
Q_1 varchar2(500),
Q_2 varchar2(500),
so on till Q_40

am using a execute immdeiate command though it doesn't show error for first 20 rows it doesn't sucessfully updates the table.
thanks

 

[carp]

Not updating any rows does not constitute an error from Oracle's perspective:

15:22:49 SQL> create table kondakindi(this_day date);
Table created.
15:23:14 SQL> insert into kondakindi values(trunc(sysdate));
1 row created.
15:23:22 SQL> insert into kondakindi select * from kondakindi;
1 row created.
15:23:38 SQL> insert into kondakindi select * from kondakindi;
2 rows created.
15:23:39 SQL> insert into kondakindi select * from kondakindi;
4 rows created.
15:23:40 SQL> insert into kondakindi select * from kondakindi;
8 rows created.
15:23:41 SQL> select * from kondakindi;
THIS_DAY
---------
20-JUN-05
20-JUN-05
20-JUN-05
20-JUN-05
20-JUN-05
20-JUN-05
20-JUN-05
20-JUN-05
20-JUN-05
20-JUN-05
20-JUN-05
20-JUN-05
20-JUN-05
20-JUN-05
20-JUN-05
20-JUN-05
16 rows selected.
15:23:48 SQL> update kondakindi set this_day = sysdate - 1
15:24:11   2  where this_day = sysdate + 1;

0 rows updated.

Note that even though none of the 16 rows was update, no error was generated.