Forum Discussion

Juergen's avatar
Juergen
Occasional Contributor
17 years ago

Problem with SEQUENCES

Hi all,

I have a problem using ORA-SEQUENCEs as a datasource in soapUI.
I using the following driver => oracle.jdbc.driver.OracleDriver.
The database is up and running, connection OK.

Now the problem.
I have created a database-sequence and a datasource in soapUI.
Now I want to recieve the next Value from the sequence and I have created the following sql-statement. But nothing happens.

SELECT TRANSACTION_ID_SEQ.nextval from dual


Please help !!!

Thanks and best regrads
Juergen

3 Replies

Sort By
  • omatzura's avatar
    omatzura
    Super Contributor
    17 years ago
    Hi Juergen,

    hmm.. are you getting any errors in the error log or console window? Can you show a screenshot of this so I can see all your settings?

    regards!

    /Ole
    eviware.com
  • Juergen's avatar
    Juergen
    Occasional Contributor
    17 years ago
    Hallo I have a solution for that problem:

    #########
    SELECT TRANSACTION_ID_SEQ.nextval as TRANSACTION_ID_SEQ  from dual
    #########


    Now it works fine.

    Regards

    Juergen