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