No offense Guus Kramer but why not use enterprise manager if you're gonna do it the same way it does it but without the User interface?? Other than can...

I'm not expert at non-equal joins and I jut can't see the problem.. hopefully somebody else will find the solution.

Good luck.

can you post the table data along with the expected results and the current results so we can work out the join?

Been there, done that... it's always so simple once you have the solution 🙂

If I understand correctly you problem, I think it's pretty much the same probleme as trying to save an image in the DB. I think what you need is...

Can't you simply merge the 2 logics?? >>

Insert into a (key1,key2,data) (Select Key1, Key2, data from tblB B where not exists (Select * from a A where A.key1 = B.Key1...

Good.. I just wish I had had an Oracle server to do some tests.. would have saved us a lot of typing :-).

I think I got you mixed up. OPENROWSET can be used in two ways :

in the first exemple I showed you I used all the information required to setup...

I think it's surprising they don't have a lot more... think about how many GB of text they published over the years... if only their software had so few...

Antares686.. on a more serious note, it is forbidden to use raiserror in a UDF. I however found a nice workaround :

CREATE FUNCTION [dbo].[fnTest] ()

RETURNS int...

Not that's normal. What it means is that the syntaxe in your query is wrong. Have you tried my query in the previous message?

I also thaught you could...

I think the first thing to do is to see if the link to oracle is working. In entreprise manager open the server where you added the linked server,...

I sent you my e-mail in your private messages section of your account.

If you are talking about a linked server then it's gonna be something like OracleServerName.DbName.Owner.Table.

How did you linked the tables?

I found another article but it seems to be only using linked server.

http://www.winntmag.com/Windows/Articles/ArticleID/22264/pg/1/1.html

BTW why can't you add a linked server to Oracle in your environement?