It is possible to use Oracle ref cursor in Qt5?



  • Hello,

    It is possible to use Oracle ref cursors in Qt5?

    (I found a patch for it, but it works only with Qt4. The Qt5 oci driver is very different from Qt4 to transfer the solution.)



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


  • Lifetime Qt Champion

    Hi and welcome to devnet,

    Maybe not on this forum ;)

    Do you have a link to the patch ?



  • [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


  • Lifetime Qt Champion

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



  • 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
    )


  • Lifetime Qt Champion

    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.



  • 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



  • 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



  • 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*)
    @



  • 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*)
    @



  • 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



  • 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


Log in to reply
 

Looks like your connection to Qt Forum was lost, please wait while we try to reconnect.