ora-6510 ora-6512 ora-1403 errors

[samdba]

Any advise please...

[tamilselvan]

SQL> desc t1
 Name                     Null?    Type
 ------------------------ -------- ----------------------------
 ID                                NUMBER(38)
 NAME                              VARCHAR2(30)

SQL> desc t2
 Name                      Null?    Type
 ------------------------ -------- ----------------------------
 ID                                 NUMBER(38)
 NAME                               VARCHAR2(30)

SQL> select * from t1;

        ID NAME
---------- ------------------------------
         1 aaaaaaa
         2 bbb
         3 ccccccccc
         4 dddddddd
         5 eeeeeee

SQL> select * from t2 ;

        ID NAME
---------- ------------------------------
         1 aaaaaaa
         3 ccccccccc
         5 eeeeeee

SQL> get ins
  1   declare
  2   L_id number ;
  3   cursor c1 is
  4      select id , name from t1;
  5   begin
  6     for c1rec in c1 loop
  7         begin
  8           select id into L_id from t2 where id = c1rec.id;
  9         exception when no_data_found then
 10           insert into t2 values (c1rec.id, c1rec.name) ;
 11         end;
 12     end loop;
 13     commit;
 14     exception when others then raise ;
 15* end;
 16  /

PL/SQL procedure successfully completed.

SQL> select * from t2;

        ID NAME
---------- ------------------------------
         1 aaaaaaa
         3 ccccccccc
         5 eeeeeee
         2 bbb
         4 dddddddd

SQL> spool off 

Is that you want?

Tamil

[samdba]

Originally posted by tamilselvan

You are the man
Thanks a lot!