Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. General and Desktop
  4. It is possible to use Oracle ref cursor in Qt5?
Forum Updated to NodeBB v4.3 + New Features

It is possible to use Oracle ref cursor in Qt5?

Scheduled Pinned Locked Moved General and Desktop
13 Posts 3 Posters 3.0k Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • I Offline
    I Offline
    ibc_nagy_imre
    wrote on last edited by
    #2

    No one use Oracle's sys ref cursors? :)

    1 Reply Last reply
    0
    • SGaistS Offline
      SGaistS Offline
      SGaist
      Lifetime Qt Champion
      wrote on last edited by
      #3

      Hi and welcome to devnet,

      Maybe not on this forum ;)

      Do you have a link to the patch ?

      Interested in AI ? www.idiap.ch
      Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

      1 Reply Last reply
      0
      • I Offline
        I Offline
        ibc_nagy_imre
        wrote on last edited by
        #4

        [quote author="SGaist" date="1400663864"]
        Do you have a link to the patch ?[/quote]

        hello,

        for Qt4 i found this and its look like works with qt4 only: "https://bugreports.qt-project.org/browse/QTBUG-166":https://bugreports.qt-project.org/browse/QTBUG-166

        1 Reply Last reply
        0
        • SGaistS Offline
          SGaistS Offline
          SGaist
          Lifetime Qt Champion
          wrote on last edited by
          #5

          Are you talking about the patch of Bill King or the attachments ?

          Interested in AI ? www.idiap.ch
          Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

          1 Reply Last reply
          0
          • I Offline
            I Offline
            ibc_nagy_imre
            wrote on last edited by
            #6

            The attachments witch is the latest version of patch i think.
            (
            Bill King: 23/Sep/09 3:11 PM
            Attachments: 29/Mar/12 7:52 PM
            )

            1 Reply Last reply
            0
            • SGaistS Offline
              SGaistS Offline
              SGaist
              Lifetime Qt Champion
              wrote on last edited by
              #7

              From a quick test, for the header patch you can copy the two additional lines in qsql_oci_p.h

              The cpp patch only fails for

              @Q_DECLARE_METATYPE(QOCIResult *)@

              That you can easily copy yourself.

              The coding style has changed a bit but it shouldn't be a real problem.

              I haven't tried to build since I don't have the SDK at hand.

              Interested in AI ? www.idiap.ch
              Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

              1 Reply Last reply
              0
              • C Offline
                C Offline
                cki61
                wrote on last edited by
                #8

                Hi SGaist,
                I’m just trying to port the QTBUG-166 attachments to Qt 5.4. As a newbee to Qt not just the easiest beginning, but I need access to Oracle Ref Cursors.
                The patched qsql_oci.cpp and qsql_oci_p.h do compile without errors, but the adapted example program doesn't.

                Questions:
                does there already exists a patch for Qt5.4?
                I need someone knowing the cursor theme who can take a look to my ported patch. Would you do this?

                I’d like to give people acces to my created patch files, but can’t find a possibility to upload. Do you know how to do it?

                Sincerely,
                CKI61

                1 Reply Last reply
                0
                • C Offline
                  C Offline
                  cki61
                  wrote on last edited by
                  #9

                  Hi SGaist,
                  I’m just trying to port the QTBUG-166 attachments to Qt 5.4. As a newbee to Qt not just the easiest beginning, but I need access to Oracle Ref Cursors.
                  The patched qsql_oci.cpp and qsql_oci_p.h do compile without errors, but the adapted example program doesn't.

                  Questions:
                  does there already exists a patch for Qt5.4?
                  I need someone knowing the cursor theme who can take a look to my ported patch. Would you do this?

                  I’d like to give people acces to my created patch files, but can’t find a possibility to upload. Do you know how to do it?

                  Sincerely,
                  CKI61

                  1 Reply Last reply
                  0
                  • I Offline
                    I Offline
                    ibc_nagy_imre
                    wrote on last edited by
                    #10

                    add to .pro: @QT += sql-private@

                    in src file:
                    @#include "QtSql/private/qsql_oci_p.h"
                    Q_DECLARE_OPAQUE_POINTER(QOCIResult*)
                    Q_DECLARE_METATYPE(QOCIResult*)
                    @

                    1 Reply Last reply
                    0
                    • I Offline
                      I Offline
                      ibc_nagy_imre
                      wrote on last edited by
                      #11

                      add to .pro: @QT += sql-private@

                      in src file:
                      @#include "QtSql/private/qsql_oci_p.h"
                      Q_DECLARE_OPAQUE_POINTER(QOCIResult*)
                      Q_DECLARE_METATYPE(QOCIResult*)
                      @

                      1 Reply Last reply
                      0
                      • C Offline
                        C Offline
                        cki61
                        wrote on last edited by
                        #12

                        Hi Imre,

                        thanks for that quick response.
                        I applied your hints to my program, but still the error:
                        'QOCIResult' was not declared in this scope

                        I think my patch isn't correct. I'd like to compare to your patch. Can you provide it to me?
                        Hope we both are talking about Qt Version 5.4!

                        Regards,
                        cki61

                        1 Reply Last reply
                        0
                        • C Offline
                          C Offline
                          cki61
                          wrote on last edited by
                          #13

                          Hi Imre,

                          thanks for that quick response.
                          I applied your hints to my program, but still the error:
                          'QOCIResult' was not declared in this scope

                          I think my patch isn't correct. I'd like to compare to your patch. Can you provide it to me?
                          Hope we both are talking about Qt Version 5.4!

                          Regards,
                          cki61

                          1 Reply Last reply
                          0

                          • Login

                          • Login or register to search.
                          • First post
                            Last post
                          0
                          • Categories
                          • Recent
                          • Tags
                          • Popular
                          • Users
                          • Groups
                          • Search
                          • Get Qt Extensions
                          • Unsolved