MQSeries.net :: View topic - Oracle Database date to ESQL function parameter input

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Oracle Database date to ESQL function parameter input

Oracle Database date to ESQL function parameter input

« View previous topic :: View next topic »

Author

Message

ajayrana

Posted: Thu Jul 17, 2014 12:02 pm Post subject: Oracle Database date to ESQL function parameter input

Apprentice

Joined: 08 May 2014
Posts: 35

Hi All,

I have written a method in esql which accepts date as one of the parameters:

Code:

CREATE FUNCTION getLastInstallmentDate(IN piDate DATE,IN piMonths INTEGER) RETURNS DATE
BEGIN
DECLARE lastInstallmentDate DATE;
SET lastInstallmentDate = getFlowStartDate(piDate);
SET lastInstallmentDate = lastInstallmentDate + CAST(piMonths AS INTERVAL MONTH);
RETURN lastInstallmentDate;
END;

Now when i m trying to use this esql in the custom esql transformation mapping and connecting the date which i have selected from the Oracle databse, this gives me an error while i m executing the flow that the type of number 1 element is not correct.

Where as when i try to pass fn:current-date to the same method it works fine.

Am i missing something on the date conversion before passing it to the ESQL method..

Thanks & Regards
Ajay Rana

Simbu

Posted: Thu Jul 17, 2014 2:17 pm Post subject:

Master

Joined: 17 Jun 2011
Posts: 289
Location: Tamil Nadu, India

ESQL data type for Oracle DATE data type is wrong.
Please check the ESQL data type that is equivalent to Oracle DATE data type and use it accordingly.
http://www-01.ibm.com/support/knowledgecenter/SSMKHH_9.0.0/com.ibm.etools.mft.doc/ak05730_.htm

ajayrana

Posted: Thu Jul 17, 2014 8:34 pm Post subject:

Apprentice

Joined: 08 May 2014
Posts: 35

Hi Simbu,

Thanks for the quick reply !! Changing the datatype to timestamp in ESQL method solved the problem.

Thanks & Regards
Ajay Rana

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Oracle Database date to ESQL function parameter input

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