It is possible to use Oracle ref cursor in Qt5?

ibc_nagy_imre

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

ibc_nagy_imre

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

SGaist

Hi and welcome to devnet,

Maybe not on this forum ;)

Do you have a link to the patch ?

ibc_nagy_imre

[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

SGaist

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

ibc_nagy_imre

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
)

SGaist

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.

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

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

ibc_nagy_imre

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

ibc_nagy_imre

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

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

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