1 Reply Latest reply: Jul 23, 2014 6:26 AM by Kgronau-Oracle RSS

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

    159080bb-6f05-4b29-8de0-dca57b290c80

      Hi,

       

      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

       

      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.

       

      Thanks