dbTalk Databases Forums  

SSIS: Executing an Oracle stor Proc with parameters

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.dts SSIS: Executing an Oracle stor Proc with parameters

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss SSIS: Executing an Oracle stor Proc with parameters in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Abba
 
Posts: n/a

Default SSIS: Executing an Oracle stor Proc with parameters - 12-01-2008 , 12:03 AM





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



Reply With Quote
  #2  
Old   
Abba
 
Posts: n/a

Default Re: Executing an Oracle stor Proc with parameters - 12-09-2008 , 02:17 AM





Anybody who can help me?

"Abba" <SQL_Help (AT) aaa (DOT) com> wrote

Quote:
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



Reply With Quote
  #3  
Old   
Abba
 
Posts: n/a

Default Re: Executing an Oracle stor Proc with parameters - 12-09-2008 , 02:17 AM


Anybody who can help me?

"Abba" <SQL_Help (AT) aaa (DOT) com> wrote

Quote:
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



Reply With Quote
  #4  
Old   
Abba
 
Posts: n/a

Default Re: Executing an Oracle stor Proc with parameters - 12-09-2008 , 02:17 AM


Anybody who can help me?

"Abba" <SQL_Help (AT) aaa (DOT) com> wrote

Quote:
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



Reply With Quote
  #5  
Old   
Abba
 
Posts: n/a

Default Re: Executing an Oracle stor Proc with parameters - 12-09-2008 , 02:17 AM


Anybody who can help me?

"Abba" <SQL_Help (AT) aaa (DOT) com> wrote

Quote:
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



Reply With Quote
  #6  
Old   
Abba
 
Posts: n/a

Default Re: Executing an Oracle stor Proc with parameters - 12-09-2008 , 02:17 AM


Anybody who can help me?

"Abba" <SQL_Help (AT) aaa (DOT) com> wrote

Quote:
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



Reply With Quote
  #7  
Old   
Abba
 
Posts: n/a

Default Re: Executing an Oracle stor Proc with parameters - 12-09-2008 , 02:17 AM


Anybody who can help me?

"Abba" <SQL_Help (AT) aaa (DOT) com> wrote

Quote:
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



Reply With Quote
  #8  
Old   
Abba
 
Posts: n/a

Default Re: Executing an Oracle stor Proc with parameters - 12-09-2008 , 02:17 AM


Anybody who can help me?

"Abba" <SQL_Help (AT) aaa (DOT) com> wrote

Quote:
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



Reply With Quote
  #9  
Old   
Abba
 
Posts: n/a

Default Re: Executing an Oracle stor Proc with parameters - 12-09-2008 , 02:17 AM


Anybody who can help me?

"Abba" <SQL_Help (AT) aaa (DOT) com> wrote

Quote:
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



Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top