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 » Stored procedures IN parameter is defined as RecordType

Post new topic  Reply to topic
 Stored procedures IN parameter is defined as RecordType « View previous topic :: View next topic » 
Author Message
broker_new
PostPosted: Tue Apr 15, 2014 4:39 pm    Post subject: Stored procedures IN parameter is defined as RecordType Reply with quote

Yatiri

Joined: 30 Nov 2006
Posts: 614
Location: Washington DC
Oracle EBS provides a predefined set of stored procedures (which Oracle calls as PL/SQL APIs) where some of the input parameters are defined as record type.

The advantage that they see by defining the input parameter as record type is.....
there are 100 to 200 input parameters that we need to pass while invoking the stored procedure... so they define the elements as part of the record structure where we can pass all elements as one parameter instead of 100 to 200 IN parameters.

IBM said that it is still a known limitation on message broker...i raised a RFE for providing the fix soon. Is there a workaround on this requirement?
_________________
IBM ->Let's build a smarter planet
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 » Stored procedures IN parameter is defined as RecordType
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.