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 Message Broker (ACE) Support » Error while calling Oracle SP from MessageBroker on AIX

Post new topic  Reply to topic
 Error while calling Oracle SP from MessageBroker on AIX « View previous topic :: View next topic » 
Author Message
uzma.khaiser
PostPosted: Tue Jul 20, 2010 6:59 pm    Post subject: Error while calling Oracle SP from MessageBroker on AIX Reply with quote

Newbie

Joined: 20 Jul 2010
Posts: 5

HI,

We have an issue where we are getting exception when calling the oracle SP from the Broker running on AIX. We have tested this out from Broker on Windows but when on AIX, this gives issues ( ORA 01008-Not all variables bound). It does not give issue for each call, but only intermittently.And when calling the SP , we are assigning parameters properly.
The Second issue with this is , its leading to CPU spiking up and killing the execution group.

the stored proc call is as below

call test_sp(arg1,arg2,agr3,Environment.Variables.resultset1,Environment.Variables.resultset2)

here arg1, arg2 are IN parameters, and arg3 is INOUT


Can anyone throw some light on this?

Thanks!
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 Message Broker (ACE) Support » Error while calling Oracle SP from MessageBroker on AIX
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.