2 Replies Latest reply on May 17, 2010 4:39 PM by Mannamal-Oracle

    A strange problem about sequence of Oracle 11g R2.

    773391
      I am trying to install oucm, and I am stucked by the init sql of connection server.
      The sequece.nextval was not return the expected value.

      The nextval cannot return expected value, the returned value is likely that the nextval was called twicely.
      INSERT INTO SINEntity(EntityID,DeliveryMethod,EntityUUID,EntityName,EntityPassword,disabled,Tracking,track_click_thru,iscatalog,ENTITYLOGIN) VALUES(SINObject_seq.*NEXTVAL*,1,'00000000-1111-2222-3333-FFFFFFFFFFFA','administrator','@YWRtaW5pc3RyYXRvcg==',0,0,0,0,'administrator');

      However the following is ok....
      select SINObject_seq.*NEXTVAL* from dual;
      INSERT INTO SINEntity(EntityID,DeliveryMethod,EntityUUID,EntityName,EntityPassword,disabled,Tracking,track_click_thru,iscatalog,ENTITYLOGIN) VALUES(SINObject_seq.*CURRVAL*,1,'00000000-1111-2222-3333-FFFFFFFFFFFA','administrator','@YWRtaW5pc3RyYXRvcg==',0,0,0,0,'administrator');

      I am new to oracle, and I am very confused.