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 5 matches
Author Message
  Topic: Procedure Call Error
sukhendu650

Replies: 8
Views: 25324
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Wed May 09, 2018 9:46 pm   Subject: Procedure Call Error
The database stored procedure parameter RC1, is it a used defined type or normal cursor

As per infocenter user-defined parameters are not supported 'User-defined types cannot be used as parameters ...
  Topic: Procedure Call Error
sukhendu650

Replies: 8
Views: 25324
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Wed May 09, 2018 5:02 am   Subject: Procedure Call Error
Hi...does your odbc settings support result sets, i.e has it got 'ProcedureRetResults=1' set at the Datasource stanza?

Also the RESULTSET used at 'RESULTSET.ResultSet1

Yes odbc settings supports ...
  Topic: Procedure Call Error
sukhendu650

Replies: 8
Views: 25324
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Wed May 09, 2018 2:55 am   Subject: Procedure Call Error
Sorry can you elaborate on this

Remember you cannot define a call against a procedure with multiple signatures.
  Topic: Procedure Call Error
sukhendu650

Replies: 8
Views: 25324
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Wed May 09, 2018 1:39 am   Subject: Procedure Call Error
below is the error
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://w ...
  Topic: Procedure Call Error
sukhendu650

Replies: 8
Views: 25324
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Wed May 09, 2018 12:28 am   Subject: Procedure Call Error
Hi All,
I am getting error while invoking the procedure sampleProc.I feel that the out parameter in call statement is giving the error but could not find any suitable alternative.

***PROCEDURE*** ...
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.