Hi,

I have a requirement where I need to insert records in DB2 using Oracle Transparent gateway in SSIS. I need to call a procedure in a package in SSIS. I am using Oracle Client to do this. When execute my script component with out passing any parameter values(meaning by just hard cording the values) it is running fine.

But when I try to pass the values using Oracle parameters and assigning values of those params to input field values, I get the below error:

ORA-01036: illegal variable name/number

at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc) at System.Data.OracleClient.OracleParameterBinding.Bind(OciStatementHandle statementHandle, NativeBuffer parameterBuffer, OracleConnection connection, Boolean& mustRelease, SafeHandle& handleToBind) at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals) at System.Data.OracleClient.OracleCommand.ExecuteNonQueryInternal(Boolean needRowid, OciRowidDescriptor& rowidDescriptor) at System.Data.OracleClient.OracleCommand.ExecuteNonQuery() at ScriptMain.Input0ProcessInputRow(Input0Buffer Row) at UserComponent.Input0ProcessInput(Input0Buffer Buffer) at UserComponent.ProcessInput(Int32 InputID, PipelineBuffer Buffer) at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.ProcessInput(Int32 inputID, PipelineBuffer buffer)

Any suggestions please?

Thanks, Deepthi

Submitted under: Microsoft SQL Server · SSIS - SQL Server Integration Services · ORACLE ·  ·