We are executing a SP on an Oracle 10g server via MSSQL, passing parameters in and back.
Some of these VARCHAR2 parameters are null, but when they come to the Oracle side, they have some garbage in them which seem to be remnants of other calls.
MSSQL 2008 R2, 11.2.0 drivers, DB 10.2.3.0
I'm faced with sending in additional parameters to signify that these parameters are null, or to make them empty strings, which isn't really what we want.
That's the wrong forum. When using MS SQL Linked Server mechanism, then you're usin an ODBC or OLEDB driver to connect from your SQL Server to Oracle.
Depending on which product you're using in the linked server config, please use the matching forum.
OLEDB: All Places > Database > Database Developer Tools > Windows and .NET > Oracle Provider for OLE DB > Discussions
ODBC: All Places > Database > Database Developer Tools > Windows and .NET > ODBC