Ok. The query hanging hasn't happened for a while, but now I got the error in the picture attached. This gets fixed if I restart the server. It happens once...

Lots of googling and some troubleshooting with the Oracle DBA. I came across one post of this issue where someone mentioned that it looked like a line feed was getting...

Ok I figured out what was going on. Some invisible character was getting tacked onto the end of the variable, probably a line feed. I could fix it by doing...

Ok, well Language is American, and Character set is UTF8. It looks like this should work fine with my current collation. Am I wrong?

I'm skeptical that it is Oracle database that is giving me the issue. But I'm the newbie, so what do I know? lol. I'll talk to my Oracle DBA and...

Well I am working on replicating from an Oracle database to my SQL Server database. How do I check the collation of the Oracle database to see if it is...

Well, I am trying to set up replication, but I get collation errors. My master database is a different collation than msdb, which is what I think is causing the...