https://community.qlik.com/t5/Talend-Studio/How-to-pass-a-cursor-to-an-Oracle-Procedure/m-p/2314604#M85355 Hello, <BR /> I need to pass a cursor containing data from a database to an Oracle Stored Procedure that is on another dabatase. <BR /> Here are the steps I need to execute : <BR /> 1) Extract data from database A and put it in a cursor <BR /> 2) Call a Stored Procedure that is on another database and pass the cursor that contains data from database A to this procedure. <BR /> 3) After execution of the Stored Proc, I need to retrieve the cursor that was passed to the Stored Proc as it now contains new information coming from database B where the Stored Proc has been executed. <BR /> 4) Read the data that is now into the cursor coming back from Stored Proc and perform some operations with the returning data. <BR /> Is it something possible with Talend ? If yes, is it possible to get some explanation as I can not find anything on Internet. <BR /> I'm using Talend Enterprise Data Integration Team Edition 5.0.1 <BR />Thank's <BR />Pascal Beaudoin <BR />Devinfo Services Conseils Fri, 03 May 2013 17:14:47 GMT Anonymous 2013-05-03T17:14:47Z https://community.qlik.com/t5/Talend-Studio/How-to-pass-a-cursor-to-an-Oracle-Procedure/m-p/2314604#M85355 Hello, <BR /> I need to pass a cursor containing data from a database to an Oracle Stored Procedure that is on another dabatase. <BR /> Here are the steps I need to execute : <BR /> 1) Extract data from database A and put it in a cursor <BR /> 2) Call a Stored Procedure that is on another database and pass the cursor that contains data from database A to this procedure. <BR /> 3) After execution of the Stored Proc, I need to retrieve the cursor that was passed to the Stored Proc as it now contains new information coming from database B where the Stored Proc has been executed. <BR /> 4) Read the data that is now into the cursor coming back from Stored Proc and perform some operations with the returning data. <BR /> Is it something possible with Talend ? If yes, is it possible to get some explanation as I can not find anything on Internet. <BR /> I'm using Talend Enterprise Data Integration Team Edition 5.0.1 <BR />Thank's <BR />Pascal Beaudoin <BR />Devinfo Services Conseils Fri, 03 May 2013 17:14:47 GMT https://community.qlik.com/t5/Talend-Studio/How-to-pass-a-cursor-to-an-Oracle-Procedure/m-p/2314604#M85355 Anonymous 2013-05-03T17:14:47Z https://community.qlik.com/t5/Talend-Studio/How-to-pass-a-cursor-to-an-Oracle-Procedure/m-p/2314605#M85356 You cannot pass a cursor from one database to another database. How do you thing should this work? <BR />You can get data from a cursor in Talend into the memory and set the values as parameters for a call of an stored procedure in another database. <BR />Your scenario is not possible as far as I know. Fri, 03 May 2013 23:48:53 GMT https://community.qlik.com/t5/Talend-Studio/How-to-pass-a-cursor-to-an-Oracle-Procedure/m-p/2314605#M85356 Anonymous 2013-05-03T23:48:53Z