November 9, 2016 at 1:55 am
i have linked server to oracle.
when i insert like that
insert into [LinkedSRV]...[xfer_in_order] (seq_id, action_type, action_code, batch_id)
values(2001, 'PTL_TEST', 'M', 'Batch001')
he put the value into oralce but oblivious of other default oracle coloume like default 0 on number data type.
but in openqey syntax its work well.
but i cant user openquery becasuse developers
plz help
November 9, 2016 at 6:34 am
liorvikel (11/9/2016)
i have linked server to oracle.when i insert like that
insert into [LinkedSRV]...[xfer_in_order] (seq_id, action_type, action_code, batch_id)
values(2001, 'PTL_TEST', 'M', 'Batch001')
he put the value into oralce but oblivious of other default oracle coloume like default 0 on number data type.
but in openqey syntax its work well.
but i cant user openquery becasuse developers
plz help
I'm pretty sure that only OPENQUERY can do what you need to do. If you expect Oracle to do an INSERT using it's DEFAULTs, then you need to provide Oracle with a query that's written in PL/SQL. INSERT statements that are purely ODBC-based are not likely to produce the desired result. If you can't use OPENQUERY because of limitations on developers having the necessary permissions within SQL Server to allow its use, then you'll have to know those default values and supply them, or, alternatively, see if you can get the powers that be in your case to allow you to code the OPENQUERY in a stored procedure and have the stored procedure run under a SQL login that does have the rights needed to use it.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
November 9, 2016 at 7:15 am
thanks man
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply