parpaa
asked on
How to call Oracle sequence via SQL server 2005 linked server
Hello Experts,
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"."EV ENTID") "
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,mess ageid from kc_gem_Event')
select '9',getutcdate(),messageid from current_diff_gen
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_
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
select '9',getutcdate(),messageid
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER