ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Interchange Server + Adapters » JDBC Adapter Parameter Type

Post new topic  Reply to topic
 JDBC Adapter Parameter Type « View previous topic :: View next topic » 
Author Message
anvanzyl
PostPosted: Tue Jul 18, 2006 6:04 pm    Post subject: JDBC Adapter Parameter Type Reply with quote

Novice

Joined: 03 Jan 2005
Posts: 19
Location: Melbourne, Australia
Hi,
I use the JDBC adapter (with WBIMB) to execute an Oracle Stored procedure. One of the parameters is "IN OUT" type (ie used as input, modified and returned). What I want to know is how I indicate this in the Application specific information in the adapter business object (i.e. what is the INOUT equavalent for IP or OP) or do I specify the parameter as both IP and OP (i.e. ...;IP=Parm1; OP=Parm1).
Currently it is specified as "IP" only and although the stored procedure is modifying it correctly, the response message contains the unchanged parameter.
_________________
Regards

Andre
IBM Certified System Administrator -- WMQ V5.3
IBM Certified Solution Designer -- WBIMB V5
Back to top
View user's profile Send private message
anvanzyl
PostPosted: Tue Jul 18, 2006 10:12 pm    Post subject: Reply with quote

Novice

Joined: 03 Jan 2005
Posts: 19
Location: Melbourne, Australia
using "IO" works.

_________________
Regards

Andre
IBM Certified System Administrator -- WMQ V5.3
IBM Certified Solution Designer -- WBIMB V5
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Interchange Server + Adapters » JDBC Adapter Parameter Type
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
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.