reported to have a DBTYPE of 130 at compile time and 5 at run time

[robfromuk]

I've researched this thoroughly and just can't find the answer.

I'm trying to execute the following linked server query:

______________________________

INSERT EditReportReal(pid, seq, action_date, clientno)
SELECT t2.pid, t2.seq, t2.action_date, t2.clientno
FROM EditReportWorking t1
JOIN mytabledetails etct2 ON t1.pid = t2.pid

_______________________________

The problem arises as seq is defined with no length and no scale but as NOT NULL in Oracle (which I guess is the meaning of the error message).

As per

http://support.microsoft.com/?id=251238

I have set the following in my create table statement:

seq NUMERIC(10) NULL,

Though I'm not sure Microsoft even have it right there.

Can anyone help at all on this?

Much appreciated.

 

[robfromuk]

... hmm not sure how to edit my post there.

Tried setting NULL and NOT NULL ... same thing either way.