How to use Between condition in Where clause of JDBC reciver scenario

[Former Member]

Hello,

My Scenario is from RFC to JDBC.

Where in RFC sends date range FromDate and toDate to JDBC. and i have date field orDate in Oracle table.

How to pass these two values (FromDate & toDate) as a range to the date field of oracle table in Key node.(Mapping)

Regards.

Sreenivas.

[Former Member]

Refer this Blog may be helpful to u .

DATE/TIME datatypes and Oracle Database

Regards

Abhishek

[prateek]

Use action=SQLQUERY and pass the complete SQL statement in the access node.

Hope this works

Regards,

Prateek

[dharamveer_gaur2]

hi

Source sturc: From date ,To date take 2 diffrent field as input side

Trarget struc: concat both field at rec side.

[Former Member]

Hi ,

u want to receive the range (Fromdata and ToDate) values in single field? I suppose we do not have this option in graphcal mapping; probabaly u can go for stored procedures.

Regards

Ganesh