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

Hi,

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

Thanks
Renuka

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

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

Hi mangatrai and Suren,

Thanks both.It worked!!!

Regards
Renuka:)

Hi,

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

Use the JDBC adapter and create a CustomSQL adapter service.