Talend - Writing multiple sql queries in tOracleRow component
Typically a row component in Talend or JasperETL is used to execute only one sql statement. There might be a situation where you want to write multiple sql statements inside a single component.. To acheive this, you simply embed ur multiple queries in a single BEGIN.....END; clause. EXAMPLE: "begin Insert into ERRORS(Errorcode,error_category,errordescription) values(1,'ERR2','FATAL ERROR'); Insert into ERRORS(Errorcode,error_category,errordescription) values(2,'ERR2','WARNING'); Insert into ERRORS(Errorcode,error_category,errordescription) values(3,'ERR2','CRITICAL ERROR'); commit; end; "