Hi Experts,
I need to execute on Oracle Qurey in Receiver JDBC.
The oracle select Query contains
1. Many Select statments in the parent select statment
2. In side child select stament there are standard SQL fiunctions like.. NVL()
3. Parent select statements is operating on 5 tables...
4. There is big where clause, in side the where clause thare are some more select statments and standard SQL functions
5. It has order by caluse as well.
On total, it was a full pledged SQL Select statment, which has all types and varieties of twists in side it.
Clinet is not agreeing for Stored Procedure. He just want to execute Big Select statment form XI and get back the resltant rows.
It is Sync scenario...
Can this be achived using XI by using Recever JDBC adatper by passing XML SQL statment..
Thanks
Subbu