topic HOW TO PASS TABLE AS INPUT PARAMTER IN TDBSP COMPONENT in Talend Studio

HOW TO PASS TABLE AS INPUT PARAMTER IN TDBSP COMPONENT

SK1694344715 — Fri, 15 Nov 2024 21:19:07 GMT

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 — Mon, 23 Oct 2023 02:46:06 GMT

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 — Mon, 23 Oct 2023 05:25:14 GMT

@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.