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 » Search

 Search found 4 matches
Author Message
  Topic: calling Oracle Stored Proc with ESQL
udayaj

Replies: 7
Views: 4739
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Mon Apr 21, 2003 10:16 am   Subject: calling Oracle Stored Proc with ESQL
Now it is going thru.But the problem is, it is not updating the string?
Can the stored procedure return the output value in the same argument.

i.e Like if I code..

SET OutputRoot.XML = InputRoo ...
  Topic: calling Oracle Stored Proc with ESQL
udayaj

Replies: 7
Views: 4739
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Fri Apr 18, 2003 5:27 am   Subject: calling Oracle Stored Proc with ESQL
That's all it shows in the exp. list.

Here is how my compute node looks like (I have tried it two ways):

1:
PASSTHRU('{call testpkg.test(?)}', InputRoot.XML.PRoot.(XML.Element)DataElement);
...
  Topic: calling Oracle Stored Proc with ESQL
udayaj

Replies: 7
Views: 4739
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Thu Apr 17, 2003 10:53 am   Subject: calling Oracle Stored Proc with ESQL
Here is my exp list:

(0x1000000)RecoverableException = (
(0x3000000)File = '/build/S210_P/src/DataFlowEngine/ImbDataFlowNode.cpp'
(0x3000000)Line = 536
...
  Topic: calling Oracle Stored Proc with ESQL
udayaj

Replies: 7
Views: 4739
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Thu Apr 17, 2003 9:53 am   Subject: calling Oracle Stored Proc with ESQL
Hi
I am trying to execute a oralce stored produce with in a compute node and I am getting an error. I am trying to pass a part of an xml string which is coming as input.

PASSTHRU('{call testpkg.t ...
Page 1 of 1

Jump to:  
Protected by Anti-Spam ACP
  
 


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

Copyright © MQSeries.net. All rights reserved.