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

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