Forum Discussion

MTognetti's avatar
MTognetti
Copper Contributor
Jun 13, 2019

Assistance Requested OpenQuery to Oracle (linked server)

Good Evening Community,    I am working on a project where I need to update Oracle Tables via a linked server on SQL Server.  I must use OpenQuery and I need that query to be parameterized.  Based ...
MTognetti's avatar
MTognetti
Copper Contributor
Jun 13, 2019

I forgot to add that the date parameter used is (sql) defined in both instances as follows: 

 

working version:

declare @procdate datetime = '2261-12-29 00:00:01.000'

 

non-working version: 

DECLARE @procdate datetime

set @procdate = '2061-12-29 00:00:01.000'

 

Thank you again. 

 

MT

 

The crazy date is for testing purposes. 

 

Thank you. 

 

MT