https://community.qlik.com/t5/Talend-Studio/Help-With-Calling-A-PL-SQL-Stored-Procedure-In-Talend/m-p/2336643#M105065 This may have been asked before, but I can't find a scenario exactly like mine on this forum. <BR />Here is my problem (I'm new to Talend and this might actually be very easy to do): <BR />I have an Oracle table on the designer in a tOracleInput component. I connect it to a tMap component to do some basic data transformation that can be handled by using Talend expressions. The output is then wired to another Oracle table in a tOracleOutput component. Where I run into a problem is that there are a few output columns that need a very specialized piece of business logic to generate. I already have a stored procedure in Oracle that handles it beautifully, accepting 7 input parameters (that would come from columns in the tOracleInput table) and outputting two output values that would be mapped to the table in the tOracleOutput component. <BR />My problem is that I can't figure out how to do this, how to use the tMap for the basic work (which is about 90% of the data) but call the stored procedure to handle the two coulns that require special processing. The job I am putting together now may have to call more than one stored procedure as there are othe output columsn that will also require special business logic. <BR />Any help would be most appreciated... Sat, 16 Nov 2024 13:29:00 GMT Anonymous 2024-11-16T13:29:00Z https://community.qlik.com/t5/Talend-Studio/Help-With-Calling-A-PL-SQL-Stored-Procedure-In-Talend/m-p/2336643#M105065 This may have been asked before, but I can't find a scenario exactly like mine on this forum. <BR />Here is my problem (I'm new to Talend and this might actually be very easy to do): <BR />I have an Oracle table on the designer in a tOracleInput component. I connect it to a tMap component to do some basic data transformation that can be handled by using Talend expressions. The output is then wired to another Oracle table in a tOracleOutput component. Where I run into a problem is that there are a few output columns that need a very specialized piece of business logic to generate. I already have a stored procedure in Oracle that handles it beautifully, accepting 7 input parameters (that would come from columns in the tOracleInput table) and outputting two output values that would be mapped to the table in the tOracleOutput component. <BR />My problem is that I can't figure out how to do this, how to use the tMap for the basic work (which is about 90% of the data) but call the stored procedure to handle the two coulns that require special processing. The job I am putting together now may have to call more than one stored procedure as there are othe output columsn that will also require special business logic. <BR />Any help would be most appreciated... Sat, 16 Nov 2024 13:29:00 GMT https://community.qlik.com/t5/Talend-Studio/Help-With-Calling-A-PL-SQL-Stored-Procedure-In-Talend/m-p/2336643#M105065 Anonymous 2024-11-16T13:29:00Z https://community.qlik.com/t5/Talend-Studio/Help-With-Calling-A-PL-SQL-Stored-Procedure-In-Talend/m-p/2336644#M105066 Hello <BR />After you do some basic data transformation on the first tMap, you can link it to another tMap and generate several output for different business logic. <BR />About how to call a strored procedure, see <BR />4278 <BR />10215 <BR />Best regards <BR />Shong Thu, 01 Apr 2010 03:04:20 GMT https://community.qlik.com/t5/Talend-Studio/Help-With-Calling-A-PL-SQL-Stored-Procedure-In-Talend/m-p/2336644#M105066 Anonymous 2010-04-01T03:04:20Z