I am trying to take a SSIS String type variable and pass it as a parameter to
a varchar2 parameter in an Oracle pl/sql stored procedure and get a binding
error (conneting via Microsoft OLE DB provider for Oracle).

Error Message:
"ORA-01008: not all variables bound.

SSIS variable (XYZ) is global in scope and data type of string.

Oracle procedure:

CREATE OR REPLACE
PROCEDURE TESTPROC2
(XYZ VARCHAR2) AS
BEGIN
NULL;
END;

Calling sql is
Declare
begin
vnapoli.testproc2 (?);
end;

Parameter mapping is
variable Name Direction dataytpe Parameter Name
XYZ Input varchar XYZ

Code page: 1252

It is looking like SSIS is not able to pass a string variable datatype to
oracle correctly. Any help would be awesome.

In your parameter mapping, try using 0 instead of specifying parameter name
explicitly. Also, check your syntax for calling the stored procedure. I would
first test your calling SQL in SQL Plus to make sure there is no problem
there.


Charles Kangai, MCT, MCDBA
Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
Services" http://www.learningtree.com/courses/134.htm
Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
http://www.learningtree.com/courses/523.htm
email: charles at kangai.demon.co.uk


"vnapoli" wrote:

PL/SQL procedure works as expected from SQL PLUS and Oracle SQL Developer.
Changed parameter name to reference of 0. Same results. ORA-01008: not
all variables bound.



"Charles Kangai" wrote: