SSIS: Executing an Oracle stor Proc with parameters

[Abba]

Hello,
[SQL2005] & [Oracle10.2.0.1.0]

I have an Oracle stored procedure 'osp_updateTable' that takes 4 input
parameters and 1 output parameter. Iam trying to execute this stored
procedure from within an SSIS package. This is the syntax Iam using after I
have established a OLEDB provider connection to Oracle

{call osp_updateTable @[User::TID], @[User::Price], @[User::Request],
@[User::Success], @[User::Error], @[User::Oerror]}

The parameters are defined thus in stored proc 'osp_updateTable' :
p_TID IN char,
p_Price IN decimal,
p_Request IN varchar,
p_Success IN char,
p_ErrorCode IN varchar,
p_error OUT number

and they are mapped thus in 'parameter mapping' tab of the "Execute SQL"
task:

@[User::TID] - varchar
@[User::Price] - decimal
@[User::Request] - varchar
@[User::Success] - varchar
@[User::Error] - varchar
@[User::Oerror] - numeric

This is the error:
The query failed to parse. Syntax error in {call...} ODBC Escape.


TIA,
AbbA

[Abba]

Anybody who can help me?

Post by Abba
Hello,
[SQL2005] & [Oracle10.2.0.1.0]
I have an Oracle stored procedure 'osp_updateTable' that takes 4 input
parameters and 1 output parameter. Iam trying to execute this stored
procedure from within an SSIS package. This is the syntax Iam using after
I have established a OLEDB provider connection to Oracle
@[User::Success], @[User::Error], @[User::Oerror]}
p_TID IN char,
p_Price IN decimal,
p_Request IN varchar,
p_Success IN char,
p_ErrorCode IN varchar,
p_error OUT number
and they are mapped thus in 'parameter mapping' tab of the "Execute SQL"
@[User::TID] - varchar
@[User::Price] - decimal
@[User::Request] - varchar
@[User::Success] - varchar
@[User::Error] - varchar
@[User::Oerror] - numeric
The query failed to parse. Syntax error in {call...} ODBC Escape.
TIA,
AbbA