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.

MERGE INTO not working in OLEDB

RubioAug 7 2018

I've had several instances of MERGE INTO statements with a complex select query working just fine in SQL Developer (which I assume is using JDBC) but failing when I try to run them in SSIS using Oracle provider for OLE DB. The error I get is ORA-00936. Is this some known limitation with Oracle OLE DB driver and if so, where can I find the docs for that? I've been able to work around this issue by creating a view for the query inside the MERGE INTO but it's a hassle that I could do without. Unfortunately I can't post the sample query because I work in a highly secure environment, but the query contains a couple of joins and several subqueries in the where clause (not exists).

Comments

EJP
The only way you can override a method in Java is by defining a class that does so, either statically or as an anonymous inner class. You can't do either of those things in JNI. Ergo you cannot do what you are asking about.
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 4 2018
Added on Aug 7 2018
0 comments
479 views