Uploaded image for project: 'Qt'
  1. Qt
  2. QTBUG-44643

QOCI: error accessing oracle ref_cursors

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: P3: Somewhat important P3: Somewhat important
    • None
    • 5.4.0, 5.12.4
    • SQL Support
    • all, mine is:
      Oracle 11.2.0.4 64bit on SLES 11.3 64bit,
      Qt 5.4 64bit on OpenSUSE 13.2 64bit,
      Oracle InstantClient 12.1.0.1 64bit

      QOCI: Accessing an explicit ref_cursor, delivered by an oracle stored function or stored procedure fails.
      This error already has been described as error QTBUG-166, date 28/Jul/06 2:45 AM by Henrik Hartz.
      The patches diff_qsql_oci.cpp.patch and diff_qsql_oci.h.patch have been added on 29/Mar/12 9:52 PM. They are written for Qt 4.1.4.
      I converted them in a 'quick and dirty' manner for Qt 5.4.
      Appended files are:

      • Oracle_ref_cursor_testscenery.sql: Create package, test table and testdata
      • qsql_oci_cpp_new.diff and qsql_oci_p_h_new.diff: diffs to apply to the appropriate files in /home/username/Qt5.4.0/5.4/Src/qtbase/src/sql/drivers/oci/
      • DB_Test.pro and main.cpp: the test project

      Please deliver an appropriate, corrected OCI module in a future release.

        1. DB_Test.pro
          0.3 kB
          Christof Kihm
        2. qsql_oci_cpp_new.diff
          5 kB
          Christof Kihm
        3. qsql_oci_p_h_new.diff
          2 kB
          Christof Kihm
        4. Oracle_ref_cursor_testscenery.sql
          5 kB
          Christof Kihm
        5. main.cpp
          3 kB
          Christof Kihm
        For Gerrit Dashboard: QTBUG-44643
        # Subject Branch Project Status CR V

            mabrand Mark Brand
            cki61 Christof Kihm
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:

                There are no open Gerrit changes