We help IT Professionals succeed at work.
Get Started
Query in Oracle for Linked Server SQL Server
Good Morning,
I would like your help to two questions:
1 - I am running a query in Oracle through Linked Server SQL Server, when I run the query I am getting the error below to column that has the case:
Msg 7347, Level 16, State 1, Line 2
OLE DB provider 'OraOLEDB.Oracle' for linked server 'LNK-SERVER01' returned data that does not match expected data length for column '[OraOLEDB.Oracle].CASE'PR
2 - I need to schedule a job in SQL Server to bring the previous day's (D-1), but do not know how to do this automatically.
I'm putting the query attached
I appreciate the help
consulta_2.txt
I would like your help to two questions:
1 - I am running a query in Oracle through Linked Server SQL Server, when I run the query I am getting the error below to column that has the case:
Msg 7347, Level 16, State 1, Line 2
OLE DB provider 'OraOLEDB.Oracle' for linked server 'LNK-SERVER01' returned data that does not match expected data length for column '[OraOLEDB.Oracle].CASE'PR
2 - I need to schedule a job in SQL Server to bring the previous day's (D-1), but do not know how to do this automatically.
I'm putting the query attached
I appreciate the help
consulta_2.txt
Why Experts Exchange?
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
Jim Murphy
Programmer at Smart IT Solutions
When asked, what has been your best career decision?
Deciding to stick with EE.
Mohamed Asif
Technical Department Head
Being involved with EE helped me to grow personally and professionally.
Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question
Connect with Certified Experts to gain insight and support on specific technology challenges including:
- Troubleshooting
- Research
- Professional Opinions
Did You Know?
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE