3 Replies Latest reply: Nov 25, 2008 10:22 PM by 502182 RSS

    Cached code??

      I am trying to debug a .NET stored procedure. I have redeployed it but Oracle seems to be using cached code instead of the code from the updated DLL. How do I clear this in Oracle?

        • 1. Re: Cached code??
          Make sure that the extproc.exe is not running in database server when you redeploy your assembly. You can stop it using OraClrAgent service. You may also manually check if your assembly in database server at <OracleHome>\bin\clr is updated after redeployment.
          • 2. Re: Cached code??
            I was able to resolve the problem by changing the assembly version and file version in the project properties. I'm not sure which one made it work, but it seems that Oracle wouldn't load in the new code if the version was the same.
            • 3. Re: Cached code??
              You may want to re-check this as currently Oracle relies on .NET DLL name and its location on the database server to use the DLL for .NET stored procedure execution.