You sure can. There are a few gotchas to be wary of but here is a test case create or replace function testodpRefCursor( uniqueId IN NUMBER ,resultItems OUT NOCOPY SYS_REFCURSOR) RETURN NUMBER IS BEGIN OPEN resultItems for select level from dual connect by level < uniqueId ; return 1; END testodpRefCursor; I have found that … Read more
May this workaround is suitable for you. You can query the LDAP server by your own and put the full connection string to your code. You can resolve the connection string from LDAP with this code: using (OracleConnection connection = new OracleConnection()) { connection.ConnectionString = “Data Source=” + ResolveServiceNameLdap(“alias”) + “;User id=user;Password=password”; connection.Open(); } … … Read more
Alex Keh from Oracle in aug 2013 says: Managed ODP.NET is released. It is currently part of the Oracle DB 12c client. To use managed ODP.NET, you have to download and install the DB client. From there, you can extract just the managed ODP.NET assembly and setup files. These files are less than 10 MB … Read more
I had the same problem and it was resolved by Thiago Lunardi’s response. Thank you. I didn’t have enough reputation to vote up your response. To mention here, I succeeded after setting my schema name in UPPERCASE. Put this in your Context file under your new dbContext class, like this: public partial class MyAppContext : … Read more
The generic answer to this question is “(Re)install ‘Oracle Developer Tools for Visual Studio’ (ODT)”. Simply getting ODP.NET from Nuget or from other sources is not enough to take advantage of Visual Studio integration. You must install ODT also. Download “ODTwithODAC”: http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html Update 4/2018: If you are using Visual Studio 2017 Community edition, please upgrade … Read more
Josh- Thank you very much for taking the time to answer. Your instructions helped a whole lot, and are very close to what I have found on my own. Interestingly enough, I found it can be slimmed a little more. For those in my situation who Do not want their users to have to install … Read more
This answer summarizes (hopefully) all the steps required, many of which documented in various places online and might save someone hours of Googling. A. How to deploy and configure Oracle.DataAccess.Client. A.1. Download ODAC112030Xcopy_64bit.zip or ODAC112030Xcopy_32bit.zip. A.1.1. Extract the content of the following folders within the zip file into your application/host’s bin/setup folder: A.1.1.1. instantclient_11_2 A.1.1.2. … Read more
Update: Oracle now fully supports the Entity Framework. Oracle Data Provider for .NET Release 11.2.0.3 (ODAC 11.2) Release Notes: http://docs.oracle.com/cd/E20434_01/doc/win.112/e23174/whatsnew.htm#BGGJIEIC More documentation on Linq to Entities and ADO.NET Entity Framework: http://docs.oracle.com/cd/E20434_01/doc/win.112/e23174/featLINQ.htm#CJACEDJG Note: ODP.NET also supports Entity SQL.
I’ve been looking into this problem further, and you simply need to grab all the appropriate DLL’s from the same downloaded version of ODP.Net and put them in the same folder as your Exe file, because ODP.Net is fussy about not mixing version numbers. I’ve explained how to do this here: http://splinter.com.au/using-the-new-odpnet-to-access-oracle-from-c Here’s the gist … Read more