how do I to call database stored procedure with record type parameters

Highlighted
One Star

how do I to call database stored procedure with record type parameters

how do I to call database stored procedure with record type parameters

 

TYPE concRec IS RECORD
(argument1 VARCHAR2 (240),
argument2 VARCHAR2 (240),
argument3 VARCHAR2 (240)

);

 

TYPE concTbl IS TABLE OF concRec
INDEX BY BINARY_INTEGER;

 

PROCEDURE submit_request (p_concTbl concTbl);

Highlighted
Community Manager

Re: how do I to call database stored procedure with record type parameters

Hi
Which DB type? Here is a documentation about how to call procedure or function in a Talend job,
https://help.talend.com/reader/ezE005k1syi0pq3WAU8WyA/Or3iSV87d~xx6xzHYrUnLA
Read the documentation and then try to use the corresponding tXXXSP for your DB type, let us know if you have any questions.

Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog