DSXchange

Hi, I have a job with STP stage, the SP in Oracle returns an Cursor.
I need to insert into a table this records, but I don't know how to make this job works. Thanks

I think you need to use the ODBC stage to call stored procedures. The out parameters of the stored procedure would be the input columns in the stage and map them to the target stage...

The SPS will return results of your to a return parameters that can be passed through an output link.