PL/SQL Exception problem

why null ? i have to update that row if unique contraint is founded

better one...

loop...
  begin
    insert stm...
  exception
  when DUP_VAL_ON_INDEX then
    change values and insert again here
  when others then 
    null;
  end;
end loop;
                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:

dont commit on every statement, put that commit after loop...

Why is not working whis :
CREATE OR REPLACE PROCEDURE TABLE_UPDATE
IS
duplicate_info  EXCEPTION;
PRAGMA EXCEPTION_INIT (duplicate_info, -00001);
loop...
  begin
    insert stm...
EXCEPTION
         WHEN duplicate_info THEN
           UPDATE MYTABLE SET
        "REGDATE" = rec.REGDATE,
        "ORIGIN" = rec.ORIGIN
// My constraint
        WHERE "DOMAIN" = rec.DOMAIN
        AND "USERNAME" = rec.USERNAME ;
    END LOOP;
END;

Its looks like syntax error - im not an expert doing this :)

In your code you've not the proper structure for a PL/SQL block (you are missing and END statement).  Should be as below.  Also, you don't need to define you're own exception, ORA-00001 is already defined for you in PL/SQL (in the SYS.STANDARD package) as DUP_VAL_ON_INDEX.  So the following should work ...

CREATE OR REPLACE PROCEDURE TABLE_UPDATE 
IS 
  LOOP ...
    BEGIN
      insert stm...
    EXCEPTION
      WHEN DUP_VAL_ON_INDEX THEN
        UPDATE MYTABLE SET
        REGDATE = rec.REGDATE,
        ORIGIN = rec.ORIGIN
        WHERE DOMAIN = rec.DOMAIN
          AND USERNAME = rec.USERNAME ;    
    END;
  END LOOP;
END;

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:

Thanks for answer me so quick but im still got errors , may be its some thing  wrong befor i call EXCEPTION ? this is the all sql statment to create procedure .
CREATE OR REPLACE  PROCEDURE "SOME_WORD"."UPDATE_TABLE" IS
BEGIN
   FOR rec IN (SELECT * FROM MY_ORIGINAL_TABLE  where rownum<='2')
   LOOP
   INSERT INTO MYTABLE
                (
       "REGDATE",
       "USERNAME",
       "DOMAIN",
       "OPTLETTER",
       "IP",
       "FIRSTNAME",
       "LASTNAME",
       "STATE",
       "ZIP",
       "COUNTRY",
       "BDATE"
               )
        VALUES (
       rec.REGDATE,
       rec.USERNAME,
       rec.DOMAIN,
       rec.OPTLETTER,
       rec.IP,
       rec.FIRSTNAME,
       rec.LASTNAME,
       rec.STATE,
       rec.ZIP,
       rec.COUNTRY,
       rec.BDATE
               );
        EXCEPTION
        WHEN DUP_VAL_ON_INDEX THEN
          UPDATE MYTABLE SET
       "REGDATE" = rec.REGDATE,
       "ORIGIN" = rec.ORIGIN
       WHERE "DOMAIN" = rec.DOMAIN
       AND "USERNAME" = rec.USERNAME ;
     END ;
   END LOOP;
COMMIT ;
END;


<code sanitized by AnnieMod, Cleanup Admin>

looks good to me, what do error you get and on which line?

ORA-06550: line 31, column 10:
PLS-00103: Encountered the symbol "EXCEPTION" when expecting one of the
following:
begin case declare end exit for goto if loop mod null pragma
raise return select update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge pipe
ORA-06550: line 39, column 9:
PLS-00103: Encountered the symbol "LOOP" when expecting one of the following:
;
ORA-06550: line 41, column 4:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the
following:
pragma