Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2007
    Posts
    5

    Unanswered: Using sequence inside INSERT

    Hi Friends
    I had this insert in oracle which
    insert into PARAMETERS (CMPT_SEQ_ID, PRMR_PARAMNAME, PRMR_SEQ_ID) values (962433,'test1',RD_Sequence.nextval)
    uses a RD_Sequence.nextval of oracle.

    In sybase we have a procedure P_GET_NEXT_SEQUENCE to do the same thing.
    How do i call this procedure inside the insert ?
    Is there any other way of doing this ?

    Thanks

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Maybe make PRMR_SEQ_ID an identity column

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •