0 Replies Latest reply: Sep 12, 2012 8:08 AM by 961642 RSS

    Query Notification fail with unhandled exception (orageneric11.dll) error

    961642
      Please help

      trying to run "Continuous Query Notification Example" from
      http://docs.oracle.com/cd/B28359_01/appdev.111/b28395/oci10new.htm

      (after some modifications example launchs and begin "waiting for Notifications")

      then i make changes in oracle table "test_table" which "myCallback" listens.
      After commit changes in table programm get notify about this changes and call function "myCallback"
      Then myCallback call function "processQueryChanges" which
      fail programm with exception in debug:
      "unhandled exception in mytest.exe (orageneric11.dll): 0x0000005 Access Violation"

      void processQueryChanges(....)
      {
      ....
      ....
      for (i=0; i < num_queries; i++)
      {
      //!!!!!fail in this string!!!!!
      checker(errhp, OCICollGetElem(envhp,
      errhp, (OCIColl *) query_changes,
      i, &exist, &query_descp, &elemind));

      --------------
      I found version of the decision
      but it doesn't work

      decision text:
      To resolve this Oracle issue add the following entry to your SQLNET.ORA file.
      # This file is actually generated by netca. But if customers choose to
      # install "Software Only", this file wont exist and without the native
      # authentication, they will not be able to connect to the database on NT.
      SQLNET.AUTHENTICATION_SERVICES = (NTS)
      DIAG_ADR_ENABLED=OFF
      DIAG_SIGHANDLER_ENABLED=FALSE
      DIAG_DDE_ENABLED=FALSE

      -------
      visual studio 6.0 sp6, oracle client 11.1.0

      Edited by: 958639 on 12.09.2012 6:00