Oracle Double Pipe Concatenation Problem

I was using an Oracle SQL statement in an Oracle Connection to do some ETL in SSIS and Visual Studio began locking up and restarting every time I clicked on the Columns tab inside the OLE DB Source Editor. Thinking there may have been a problem with the SQL, I first executed it in SQL Tools and had no problem running it there. I checked with a coworker who knows more Oracle syntax than I and he decided to remove the double pipes, || and use the CONCAT() function instead. It was a shot in the dark but SSIS likes it and the package runs fine. Could it be there is a bug in SSIS?