how i can use oracle sequence in webmethods to generate a unique id

, ,
1

Hi,

I want to generate a unique id with oracle sequence in webMethods.
Is it possible??

Thanks
Renuka

2

You could use ‘select .nextval from dual’ statement to get the Oracle sequence’s next value in webMethods and use it.

3

As said by suren, you can use it with nextval. rest you have to make sure that you make sequence configuration on database side.

4

Hi mangatrai and Suren,

Thanks both.It worked!!!

Regards
Renuka:)

5

Hi,

I cant use pub.db:execSQL is there any other way to do it

6

Use the JDBC adapter and create a CustomSQL adapter service.