Hello,I am using the Microsoft Oracle Source Component by Attunity.I would like to call an Oracle stored procedure that is doing a SELECT *.Thus I have to questions:1) Do I have to create an Oracle Stored Procedure that is returning a REF COURSOR?2)How can I call itin the Microsoft Oracle Source Component by Attunity?An example would be really appreciated.Thank youBest RegardsAntonio

Hi AntonioCH, 1. Try to execute the store procedure in SQLPlus. Copy the code if it works. 2. Besure you have a connection to the Oracle database. 3. First try the Store Procedure PL/Sql in a Execute SQL Task, check the resultset 4. Copy the code to Source Component by Attunity. Correct way to call a Store Procedure is {call <schema>.<Proc Name> } Beste regards, Naween