Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle OLEDB in SSIS Lookup can't parameterize

SMerrill8Aug 9 2017

When using the SSIS Lookup tool with Oracle OleDB 11.2, and clicking the Advanced > Parameters command button

My Oracle SQL Statement is :

in the SqlCommand Property:

select * from table where a=:a and b=:b

In the SqlCommandParam Property:

select * from table where a=? and b=?

I get the following error;

Microsoft Visual Studio

Parameters cannot be extracted from the SQL statement. The provider might not help to parse parameter information from the statement.

ADDITIONAL INFORMATION:

Provider cannot derive parameter information and SetParameterInfo has not been called. (OraOLEDB)

Who's bug is this: Oracle's or Microsoft's?

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 6 2017
Added on Aug 9 2017
0 comments
1,568 views