MQSeries.net :: View topic - Query Oracle sequence object from Oracle

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Query Oracle sequence object from Oracle

Query Oracle sequence object from Oracle

« View previous topic :: View next topic »

Author

Message

Amitha

Posted: Wed Dec 09, 2009 1:38 pm Post subject: Query Oracle sequence object from Oracle

Voyager

Joined: 20 Nov 2009
Posts: 80
Location: Newyork

Hi,

I am querying oracle sequnce object to get unique transaction ID but the return type is decimal instead of integer. Here is the code:

Code:

PASSTHRU ('SELECT seqobjectName.NEXTVAL AS SEQUENCENUMBER from DUAL' TO Database.dsname )

This returns decimal numbers like 1.0,2.0.... so on..
Normal sql command on oracle sqlplus returns interger.

Is this the way Passthru function works?
Is there any other way I can query sequence object from esql?

I can convert the return value from in my esql to integer, but i want to do that in the query itself. Let me know folks. WMB 6.1.0.5 and oracle 11g

Thanks,
Amitha

Amitha

Posted: Wed Dec 09, 2009 2:14 pm Post subject:

Voyager

Joined: 20 Nov 2009
Posts: 80
Location: Newyork

Quote:

PASSTHRU ('SELECT CAST( seqobjectName.NEXTVAL AS INTEGER) AS SEQUENCENUMBER from DUAL' TO Database.dsname )

This returns integer value.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Query Oracle sequence object from Oracle

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP