This limitation is based on older Windows restrictions, where length of environmental variables was important. This limitation is still there in the Oracle installation. Work around this: Step 1: Copy the value of your ‘path’ variable to a text-editor (Ex.: notepad) and save this value as backup. Step 2: Reduce the size of this path … Read more
The minimum configuration to properly run sqlplus from the shell is to set ORACLE_HOME and LD_LIBRARY_PATH. For ease of use, you might want to set the PATH accordingly too. Assuming you have unzipped the required archives in /opt/oracle/instantclient_11_1: $ export ORACLE_HOME=/opt/oracle/instantclient_11_1 $ export LD_LIBRARY_PATH=”$ORACLE_HOME” $ export PATH=”$ORACLE_HOME:$PATH” $ sqlplus SQL*Plus: Release 11.1.0.7.0 – Production on … 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
A simple way to find this out in Windows is to run SQLPlus from your Oracle homes’s bin directory and then check Task Manager. If it is a 32-bit version of SQLPlus, you’ll see a process on the Processes tab that looks like this: sqlplus.exe *32 If it is 64-bit, the process will look like … Read more
ok guys. figured it out. I was hitting F5 (as in MSSQL query analyzer) to run the query. That is “run script” in this client. F9 or Ctrl + Enter get me to the query results grid view. Hopefully this helps someone else in the future.
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