declare @ImportID int

select @ImportID = (select ID from openquery([fis-dev], 'select SEQ_IMPORT_PROCESS_ID.NEXTVAL as ID from dual'));
select @ImportID;
insert openquery([fis-dev], 'select TABLE_NAME, DATE_BEGIN, PROCESS, ID from IMPORT_PROCESS')
select TABLE_NAME = N'CREDIT'
        ,DATE_BEGIN = getdate()
        ,PROCESS = 1
        ,ID = @ImportID
select 'after 1 insert';
select @ImportID = (select ID from openquery([fis-dev], N'select SEQ_IMPORT_PROCESS_ID.NEXTVAL as ID from dual'));
select @ImportID;
insert openquery([fis-dev], N'select TABLE_NAME, DATE_BEGIN, PROCESS, ID from IMPORT_PROCESS')
select TABLE_NAME = N'CREDIT_COUNTER'
        ,DATE_BEGIN = getdate()
        ,PROCESS = 1
        ,ID = @ImportID
select 'after 2 insert';

1513
   

1 row(s) affected.
   

after 1 insert
   

1514
   

[Microsoft][ODBC SQL Server Driver][SQL Server]The OLE DB provider "OraOLEDB.Oracle" for linked server "fis-dev" supplied inconsistent metadata. An extra column was supplied during execution that was not found at compile time.(42000,7353)