How to call Oracle sequence via SQL server 2005 linked server
Posted on 2012-03-19
I am having trouble inserting rows into a Oracle table (which has a sequence generator) via SQL server 2005 linked server. If i dont include the column it errors out saying
'"ORA-01400: cannot insert NULL into ("STKANAQA_USER1"."KC_GEM_EVENT"."EVENTID") "
EventId is the column which is being enforced by sequential value. I am not sure how to call it from SQL server.
Insert OPENQUERY(STKANAQA,'select eventtypeid,eventdate,messageid from kc_gem_Event')
select '9',getutcdate(),messageid from current_diff_gen