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_
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
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
Microsoft SQL Server 2005Oracle DatabaseMicrosoft SQL Server
Last Comment
parpaa
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Yep that helped. There might be multiple records.. I will try to use a cursor to insert. Thanks again!!