This discussion is archived
5 Replies Latest reply: Mar 25, 2012 10:51 AM by 925997 RSS

OCCI, VS2010 problem

918961 Newbie
Currently Being Moderated
Hi everyone,

well after a lot of trouble i still get the following error message: "The procedure jump point "OCILobGetOptions" was not found at DLL "oci.dll" "
and in german: "Der Prozedureinsprungpunkt "OCILobGetOptions" wurde in der DLL "Oci.dll" nicht gefunden"

The error occur after i start my aplication.

i use:
- 11g Client,
- occivc10_11202_win32.zip
- Visual Studio 2010
- WinXP SP3

i really hope that someone can help me!
  • 1. Re: OCCI, VS2010 problem
    423410 Explorer
    Currently Being Moderated
    Can you pls explain when you get this message.
    Even with just a createEnvironment in your code and your try to compile and link or when if you are using a specific class ?
  • 2. Re: OCCI, VS2010 problem
    918961 Newbie
    Currently Being Moderated
    Thanks for the response...

    well the error occur after i compiled and linked the project and then start the aplication. Here ist the code i hope it will help:
    #include "Employees.h"

    using namespace oracle::occi;
    using namespace std;

    int main (void)
    {
         Employees *pEmployees= new Employees();

         pEmployees->List();

         delete pEmployees;

         cout << "Enter um fortzufahren...";

         cin.get();

         return 0;
    }

    Employees::Employees()
    {

         user = "Test";
         passwd = "xxxx";

         db = "Server1:1521/Ora10";

         env = Environment::createEnvironment(Environment::DEFAULT);

         try
         {
              con = env->createConnection(user, passwd, db);
         }catch (SQLException& ex){
              cout << ex.getMessage();     
              exit(EXIT_FAILURE);
         }
    }

    Employees::~Employees()
    {
         env->terminateConnection(con);

         Environment::terminateEnvironment(env);
    }

    void Employees::List()
    {

         Statement *stmt = NULL;
         ResultSet *rs = NULL;
         string sql = "SELECT * FROM INFO";

         try
         {
              stmt = con->createStatement(sql);
         }catch( SQLException& ex){
              cout << ex.getMessage();
         }

         if (stmt)
         {
              try
              {
                   stmt->setPrefetchRowCount(32);

                   rs = stmt->executeQuery();
              }catch( SQLException& ex){
              cout << ex.getMessage();
              }

              if(rs)
              {
                   cout << "Ausgabe:" <<endl;

                   while (rs->next()){
                        cout << rs->getInt(1) << endl;
                   }
                   cout << endl;

                   stmt->closeResultSet(rs);
              }
         }
    }
    well i will try somethink tomorrow and hope that it will work :D
  • 3. Re: OCCI, VS2010 problem
    423410 Explorer
    Currently Being Moderated
    Can you check if you are using the correct oraocci11.dll and right version of the compiler and ORACLE_HOME is pointing to the right installation.
    You may also want to check if you have any entries in the registry apart from the env variables set.
    Such weird errors are possible only if there is a mismatch in your setup.
  • 4. Re: OCCI, VS2010 problem
    918961 Newbie
    Currently Being Moderated
    well i checked all your points and could not find any problems.. :(

    After i changed
    db = "Server1:1521/Ora10"; -> db = "Server1:1521/Ora10g";
    it worked fine last thursday!

    This change worked at 2 different systems...
    but now after the weekend i get another weird error and i did not changed any systemconfigurations :(
    now i also cleaned the registry...

    and i still get a similiar error like the first one: "The procedure jump point "OCIPHeapAllocUc" was not found at DLL "oci.dll" "

    Edited by: 915958 on 28.02.2012 04:24
  • 5. Re: OCCI, VS2010 problem
    925997 Newbie
    Currently Being Moderated
    Do you have oraclient version >= 11.2.0.2.0? I had the same issue (OCIPHeapAllocUc symbol not exported by oci.dll) and I installed the 11.2.0.2.0 client version and it solved the problem.

    Best regards.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points