Previous Next

Thread: Seeing garbage data added to Stored Procedure return strings when called from ASP

Last post 07-25-2008 9:49 AM by 46er. 0 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (1 items)

Sort Posts:

  • 07-25-2008, 9:49 AM

    • 46er
    • Not Ranked
    • Joined on 07-25-2008, 9:29 AM
    • Posts 1

    Seeing garbage data added to Stored Procedure return strings when called from ASP

    We had a working ASP page on a Windows 2003 Server/IIS6. The ASP page called an Oracle Stored Procedure out on an Oracle Server. The SP returns 2 string values. Everything is fine. The Server was brought down to apply some Windows Updates and brought back up. When it was brought back up, all of a sudden the 2 return strings from the SP have garbage characters tacked on behind the strings returned from the SP. So I have the proper return value followed by nonsense. They backed out the Windows Updates and it worked for a while but then started again. If we do an IIS Reset, it is good for several calls to the SP but eventually starts coming back with corrupt data attached again.

    This same ASP page works fine on a Test Server with the same configuration as the Production Server but has not had the Windows Updates applied to it. The only other difference between the Production Server and Test Server is that the Test Server has Oracle Client 10 and the Production Server has Oracle Client 8.

    Is there a way to log/capture the data coming through IIS back to the ASP Page from the SP?

     

Page 1 of 1 (1 items)
Page view counter