November 8, 2016 at 8:02 am
i have somthing strnage.
when i run this command in mssql
insert into [LinkedSRV]...[xfer_in_order] (seq_id, action_type, action_code)
values(2001, 'PTL_TEST', 'M')
i get error :
OLE DB provider "OraOLEDB.Oracle" for linked server "LinkedSRV" returned message "ORA-02290: check constraint (CT2.DF_XFER_IN_ORDER_WAVE_SEQ) violated".
but if i run this insert localy in oracle - its worked
insert into xfer_in_order (seq_id, action_type, action_code)
values(2001, 'PTL_TEST', 'M') 2 ;
1 row created.
November 8, 2016 at 8:06 am
liorvikel (11/8/2016)
i have somthing strnage.when i run this command in mssql
insert into [LinkedSRV]...[xfer_in_order] (seq_id, action_type, action_code)
values(2001, 'PTL_TEST', 'M')
i get error :
OLE DB provider "OraOLEDB.Oracle" for linked server "LinkedSRV" returned message "ORA-02290: check constraint (CT2.DF_XFER_IN_ORDER_WAVE_SEQ) violated".
but if i run this insert localy in oracle - its worked
insert into xfer_in_order (seq_id, action_type, action_code)
values(2001, 'PTL_TEST', 'M') 2 ;
1 row created.
Not sure what your question is here.
What is the definition of check constraint CT2.DF_XFER_IN_ORDER_WAVE_SEQ?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
November 8, 2016 at 8:19 am
its not error constranit realy.
when i run this insert throw oracle localy (not throw dblink from mssql)
its worked .
but if i disable all constaint in oracle . that mssql dblink to oracle will work and its bad for me
November 8, 2016 at 9:01 am
liorvikel (11/8/2016)
its not error constranit realy.when i run this insert throw oracle localy (not throw dblink from mssql)
its worked .
but if i disable all constaint in oracle . that mssql dblink to oracle will work and its bad for me
Is there a reason why you've chosen not to answer my question?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply