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: Problem with Date field in stored procedure calling
integrator

Replies: 0
Views: 2581
 PostForum: WebSphere Interchange Server + Adapters   Posted: Mon May 14, 2007 6:52 am   Subject: Problem with Date field in stored procedure calling
Hi Guys,

Can you please help me with a problem of invoking stored procedure with Date data type as a parameter.

I need to invoke a stored procedure through WBI Oracle Apps Adapter. In the BO def ...
  Topic: How to pass record set into stored procedure through adapter
integrator

Replies: 4
Views: 5180
 PostForum: WebSphere Interchange Server + Adapters   Posted: Tue Mar 27, 2007 11:36 pm   Subject: How to pass record set into stored procedure through adapter
Thank you for your reply.

I gave the procedure as a simple sample procedure. The actual procedure, is much more complex, with a lot of sub-procedure calling and also large in size.

Also the FET ...
  Topic: How to pass record set into stored procedure through adapter
integrator

Replies: 4
Views: 5180
 PostForum: WebSphere Interchange Server + Adapters   Posted: Wed Mar 21, 2007 11:03 pm   Subject: Definition of SP
The requirement is for simple RecordSet passing.
The procedure may look like the following:


PROCEDURE testSP(
param IN SYS_REFCURSOR ) AS

v_id ERP_TABLE.ID%TYPE;
v_detail ERP ...
  Topic: How to pass record set into stored procedure through adapter
integrator

Replies: 4
Views: 5180
 PostForum: WebSphere Interchange Server + Adapters   Posted: Wed Mar 21, 2007 7:14 am   Subject: How to pass record set into stored procedure through adapter
Hi,

is it possible to pass a Record set into stored procedure as a parameter through WBI adapter from MQ?

If it is then, how is it possible? What are the configurations required for passing reco ...
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.