http://www.sqlservercentral.com/blogs/dataonwheels/2012/04/03/oracle-tips-for-msbi-devs-1-executing-an-oracle-stored-proc-with-no-parameters-in-ssis-execute-sql-task/

Printed 2014/04/19 03:48PM

Oracle Tips for MSBI Devs #4: Executing an Oracle Stored Proc with IN Parameters in SSIS Execute SQL Task

2012/04/03

The first tip I published discussed how to execute an Oracle procedure with no parameters.  In this tip, I will discuss a technique that works with IN parameters in an Oracle stored procedure. After many unsuccessful attempts at executing a stored procedure with parameters, the following pattern was developed by a one of my peers [...]

Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.