HOW TO PASS TABLE AS INPUT PARAMTER IN TDBSP COMPO... - Qlik Community

SK1694344715 · ‎2023-10-20

Hi All,

How to pass Table as Input parameter into tDBSP component.

ALSO, Which option we need to select in SCHEMA for Table parameter.

NEED IMMEDIATE HELP.

THANKS IN ADVANCE.

Anonymous · ‎2023-10-22

Hello,

You could use use tDBInput (the source of tDBInput could be any query) to generate the input value and pass it tDBSP, for exmaple:

tDBInput--main--tDBSP.

Best regards

Sabrina

SK1694344715 · ‎2023-10-23

@Xiaodi Shi thank you.

Can you provide the sample code for same.

I have created new user defined table-type and passing to SP as parameter in oracle and working fine.

Not sure to pass same on talend, please help with sample code.

HOW TO PASS TABLE AS INPUT PARAMTER IN TDBSP COMPONENT