Skip to Content
0
Former Member
Jan 02, 2012 at 07:56 AM

JDBC graphical lookup for stored procedure

87 Views

Hi All,

We have a requirement for JDBC lookup.

At JDBC side we have a stored procedure which taking a request and fetching data from 4 different tables.

Now We want to call this SP in our JDBC lookup at PI mapping.

But I am not sure how to call SP within the graphical lookup tab.

Also we have doubt on which table structure need to be imported in PI.

Need to import all 4 table or we need to create a view at JDBC side and import the structure?

Is there any way we can call SP name at JDBC receiver channel?.

Thanks,

Navneet