Search code examples
oracle-databasestored-procedurestalend

Execute Stored Procedure Talend

I try to execute a stored procedure with Talend 7.1.1. That procedure is registered in DB 'SYS' and she TRUNCATE the table in parameter (my table : ODS.TEMPF_PRODUCTION)

I put the composent tDBSP (ORACLE), I connected it to my database 'SYS' where is stored my procedure 'TRUNCATE_TABLE' but I don't know where I need to inform my parameter table_name.

My component: enter image description here

enter image description here If someone can tell me what is missing, I would be grateful !

Solution

  • The designer: enter image description here

    The tDBSP conected to my DB 'SYS': enter image description here

    The tFixedFlowInput send the name of my table to the parameter 'table_name' from the procedure: enter image description here

    That's working perfectly ! Thx to Alex Poole.