2 Replies Latest reply on Nov 1, 2016 7:43 PM by thomaso2

    Cannot run .net stored procedure

    thomaso2

      I'm very new to .net stored procedures.

      So please excuse my perhaps stupid questions.

      My environment:

      Windows 8.1 Pro.

      Oracle 12c 12.1.0.1.0

      ODTwithODAC121024

      Oracle Developer Tools for Visual Studio 2013

      Microsoft Visual Studio 2013 Pro

      My laptop acts as Oracle database server and Oracle client. (two separate oracle homes)

       

      Following docs I've installed ORAC and Oracle Development tools.

      I can run all client examples, my programs connect to database, executes queries.

      I can create Oracle Stored Procedure project in VS 2013. I can compile my sample .NET Stored Procedure program. I can successfully deploy created DLL to Oracle database home ...bin/clr folder.

      Oracle wizard creates library and wrapper pl/sql procedure or function.

      But....

      When I try to run test program it comes whit this error message:

       

      ORA-20100: System.IO.FileNotFoundException

      Could not load file or assembly 'Oracle.DataAccess, Version=4.121.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.

         at Project2.Class1.getDepartmentno(Int32 employee_id)

      ORA-06512: at "SYS.DBMS_CLR", line 152

      ORA-06512: at "<...>.GETDEPARTMENTNO", line 7

       

      What am I messing?

      How to fix this error.

       

      TIA

      Thomaso