Results 1 to 3 of 3

Thread: oracle sequence

  1. #1
    Join Date
    Aug 2006
    Posts
    31

    Question Unanswered: oracle sequence

    Hey all,

    can anyone tell me how to access the next value in a sequence through occi?

    i am having troube, as reqnum.nextval doesnt work

    thanks for lookin

    Scott

  2. #2
    Join Date
    Jul 2006
    Posts
    49
    you can run it like any other SELECT statement. Prepare a variable to store the result of your query, and then stick a SELECT statement into your code that looks like this,
    select reqnum.nextval from dual;
    Sorry, I'm not an occi guy, but I assume you already know the syntax for declaring vars and storing query results.

  3. #3
    Join Date
    Aug 2006
    Posts
    31

    Talking

    ah fantastic! i didnt realise it was so simple

    thanx for replying to me, you have helped me loads with my task

    yours,

    Scott

Posting Permissions

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