1 Reply Latest reply: Feb 22, 2012 4:43 AM by Sudheendra-Oracle RSS

    Oracle OCCI env->createConnection fails with ORA-24550

    918304
      I'm trying to connect with Oracle (express) using OCCI. My program is working on linux and OSX but when I try to use it on Windows it fails. I don't get a seg fault, it doesn't throw an exception (at least try {} catch(...) {} doesn't catch anything), the program just stops and goes away.

      Here is what I'm trying to do.

      try {
      oracle::occi::Environment* env =
      oracle::occi::Environment::createEnvironment(
      oracle::occi::Environment::THREADED_MUTEXED);
      env->createConnection("test", "test", "//192.168.0.25:1521/");
      } catch (oracle::occi::SQLException &ex) {
      printf("sql exception\n");
      } catch (...) {
      printf("unknown exception\n");
      }
      I've also tried oracle::occi::Environment::DEFAULT and it gives me:

      ORA-24550: signal received: Unhandled exception: Code=c0000005 Flags=0
      I'm able to connect using SQL*Lite with the following connection string:

      sqlplus.exe "test/test@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.25)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=XE)))"

      The full code is here: https://github.com/nearinfinity/node-oracle