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 3 matches
Author Message
  Topic: Invoking SP Oracle with OUT REF CURSOR from ESQL WMB 6.1
atreyu5

Replies: 6
Views: 3191

PostForum: WebSphere Message Broker (ACE) Support   Posted: Thu Sep 16, 2010 7:28 am   Subject: Invoking SP Oracle with OUT REF CURSOR from ESQL WMB 6.1
Well, I've installed the Datadirect Driver for Oracle and it works!

So, it's a driver problem?

Are there any Oracle, IBM or Ms option?

Thanks,
  Topic: Invoking SP Oracle with OUT REF CURSOR from ESQL WMB 6.1
atreyu5

Replies: 6
Views: 3191

PostForum: WebSphere Message Broker (ACE) Support   Posted: Thu Sep 16, 2010 6:53 am   Subject: Invoking SP Oracle with OUT REF CURSOR from ESQL WMB 6.1
Do you refer to the advance configuration of the ODBC driver?

I have: Enable Result Sets (ON) and Enable Closing Cursors (ON).

But, I haven't one called: ProcedureRetResults

Thanks,
  Topic: Invoking SP Oracle with OUT REF CURSOR from ESQL WMB 6.1
atreyu5

Replies: 6
Views: 3191

PostForum: WebSphere Message Broker (ACE) Support   Posted: Thu Sep 16, 2010 6:03 am   Subject: Invoking SP Oracle with OUT REF CURSOR from ESQL WMB 6.1
Hi,

I'm trying to invoke an Oracle's SP from ESQL, but I get this error at the end of the stacktrace:

DatabaseException
File:CHARACTER:F:\build\S610_P\src\DataFlowEngin ...
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.