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

QOCI: error accessing oracle ref_cursors

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • 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

    Description

      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.

      Attachments

        1. DB_Test.pro
          0.3 kB
        2. main.cpp
          3 kB
        3. Oracle_ref_cursor_testscenery.sql
          5 kB
        4. qsql_oci_cpp_new.diff
          5 kB
        5. qsql_oci_p_h_new.diff
          2 kB

        Issue Links

          For Gerrit Dashboard: QTBUG-44643
          # Subject Branch Project Status CR V

          Activity

            People

              andysh Andy Shaw
              cki61 Christof Kihm
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Gerrit Reviews

                  There is 1 open Gerrit change