Forum Stats

  • 3,781,636 Users
  • 2,254,533 Discussions


Cannot run .net stored procedure

thomaso2 Member Posts: 8
edited Nov 1, 2016 3:43PM in .NET Stored Procedures

I'm very new to .net stored procedures.

So please excuse my perhaps stupid questions.

My environment:

Windows 8.1 Pro.

Oracle 12c


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.


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=, 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.




This discussion has been closed.