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 IndexWebSphere Message Broker SupportStored Procedure returning NULL value from message flow

Post new topicReply to topic
Stored Procedure returning NULL value from message flow View previous topic :: View next topic
Author Message
mainak
PostPosted: Thu Dec 23, 2010 1:57 am Post subject: Stored Procedure returning NULL value from message flow Reply with quote

Newbie

Joined: 18 Aug 2010
Posts: 7

Hi,
I have written a Dynamic Stored Procedure which is running in a remote server and is fetching mutliple records from Customer Database. Now, the stored procedure in running perfectly. When I am testing from TOAD, I am getting the desired result. But, we I am calling the Stored Procedure from code written in ESQL deployed in MB 6.1, the stored procedure is returning NULL value in my message flow.

The code in my messsage flow where I am declaring and calling the stored procedure is:-

CREATE PROCEDURE GPSD_storedProcedure(IN databaseName CHARACTER,
IN MSISDN CHARACTER,
OUT wcud CHARACTER,
OUT voucherbarstatus INT,
OUT callbarstatus INT,
OUT installationdate DATE,
OUT firstcalldate DATE,
OUT activationdate DATE,
OUT deactivationdate DATE,
OUT deactivated DATE,
OUT balanceforfeiteddate DATE,
OUT balanceforfeitedat DATE,
OUT expirationdate DATE,
OUT deletedat DATE,
OUT substatus CHARACTER,
OUT amountstd INT,
OUT amountTT INT,
OUT novoucherbar INT,
OUT spday CHARACTER,
OUT fcc CHARACTER,
OUT hcm CHARACTER,
OUT msd CHARACTER,
OUT med CHARACTER)
LANGUAGE DATABASE EXTERNAL NAME "SOAADM.GPSD_storedProcedure";

DECLARE wcud CHARACTER;
DECLARE voucherbarstatus INT;
DECLARE callbarstatus INT;
DECLARE installationdate DATE;
DECLARE firstcalldate DATE;
DECLARE activationdate DATE;
DECLARE deactivationdate DATE;
DECLARE deactivatedat DATE;
DECLARE balanceforfeiteddate DATE;
DECLARE balanceforfeitedat DATE;
DECLARE expirationdate DATE;
DECLARE deletedat DATE;
DECLARE substatus CHARACTER 'Hello';
DECLARE amountstd INT;
DECLARE amountTT INT;
DECLARE novoucherbar INT;
DECLARE spday CHARACTER;
DECLARE fcc CHARACTER;
DECLARE hcm CHARACTER;
DECLARE msd CHARACTER;
DECLARE med CHARACTER;

CALL GPSD_storedProcedure(Environment.Variable.DatabaseName,
Environment.Variable.MSISDN,
wcud,
voucherbarstatus,
callbarstatus,
installationdate,
firstcalldate,
activationdate,
deactivationdate,
deactivatedat,
balanceforfeiteddate,
balanceforfeitedat,
expirationdate,
deletedat,
substatus,
amountstd,
amountTT,
novoucherbar,
spday,
fcc,
hcm,
msd,
med);

Now, substatus should return is returning I and installationdate is returning 20-AUG-10 when I am calling from Toad. But from MB, it is returning NULL.

The declaration of the stored procedure which is working fine is:--

CREATE OR REPLACE PROCEDURE GPSD_storedProcedure(pDatabaseName_catalog IN VARCHAR2,
MSISDN IN VARCHAR2,
wcud OUT VARCHAR2,
voucherbarstatus OUT NUMBER,
callbarstatus OUT NUMBER,
installationdate OUT DATE,
firstcalldate OUT DATE,
activationdate OUT DATE,
deactivationdate OUT DATE,
deactivatedat OUT DATE,
balanceforfeiteddate OUT DATE,
balanceforfeitedat OUT DATE,
expirationdate OUT DATE,
deletedat OUT DATE,
substatus OUT VARCHAR2,
amountstd OUT NUMBER,
amountTT OUT NUMBER,
novoucherbar OUT NUMBER,
spday OUT VARCHAR2,
fcc OUT VARCHAR2,
hcm OUT VARCHAR2,
msd OUT VARCHAR2,
med OUT VARCHAR2)
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:
Post new topicReply to topic Page 1 of 1

MQSeries.net Forum IndexWebSphere Message Broker SupportStored Procedure returning NULL value from message flow
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.