MQSeries.net :: View topic - Problem with Date field in stored procedure calling

integrator

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 definition, the field datatype is Date (the procedure parameter is also date). But when ever the adapter is encountering the date field as an input parameter for the procedure, it is giving an error, and is stop processing the next fields.

If I modify the BO and make the Date datatype a String datatype, the procedure is being invoked successfully.

For example, to invoke a stored procedure with 3 parameters (the second parameter is a date field), the error message is like this in the trace file:

[Mesg: :[Type: Trace] [MsgID: 90018] [Mesg: Entering execSP] ]
[Mesg: :[Type: Trace] [MsgID: 33025] [Mesg: Number of SP Parameters : 3] ]
[Mesg: :[Type: Trace] [MsgID: 31006] [Mesg: Stored Procedure Name is TEST_EMP_TABLE_INSERT] ]
[Mesg: :[Type: Trace] [MsgID: 31004] [Mesg: Value of IP is ID] ]
[Mesg: :[Type: Trace] [MsgID: 31005] [Mesg: Type of IP is String] ]
[Mesg: :[Type: Trace] [MsgID: 31004] [Mesg: Value of IP is DOB] ]
[Mesg: :[Type: Trace] [MsgID: 31005] [Mesg: Type of IP is Date] ]
[Mesg: :[9543] DoVerbFor cookie=ConsumeSync rc=-1 rtnObj.status=4 rtnObj.message=null]
[Mesg: :Receiver.processBO: Status returned from receiverCallback : -1]
[Mesg: :In jms.Receiver.processBO(msg), syncDrvCallback.receiverCallback(boMsg) returns a status < 0, indicating a failure has happened in the callback function.]
[Mesg: :Sending fault message:

Can any one please help me out of the problem? I have set the proper date format in the "DateFormat" property the configuration file. I have also tried to set the "RDBMS.initsession" property of the adapter configurator file, to set the DATE FORMAT in the Oracle session, but that is still not working.