Stored Procedure in Oracle

lcabreram97 · Post by **lcabreram97** » Thu Jul 28, 2005 12:36 pm

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

ririr · Post by **ririr** » Thu Jul 28, 2005 12:42 pm

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...

sjhouse · Post by **sjhouse** » Fri Jul 29, 2005 7:22 am

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