Forum Stats

  • 3,769,586 Users
  • 2,252,984 Discussions
  • 7,875,109 Comments

Discussions

Cannot run .net stored procedure

thomaso2
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 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

Answers

This discussion has been closed.