1 Reply Latest reply on Jul 23, 2014 11:26 AM by Kgronau-Oracle

    Garbage data for NULLs when executing an SP via MSSQL linked-servers




      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


      Any ideas?


      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.