QOpenOCCI Oracle SQL Plugin

[deivisj]

thanks a_white.
My mistake .
The main error was with bindValue. Your example and QT example how to call procedure works fine. This example correct to...

QSqlQuery procedure(DB);
procedure.prepare("call shemename.packagename.procedurename(:0,:1)");
procedure.bindValue(0, "parameter1");
procedure.bindValue(1, "parameter2");
if (!procedure.exec())
     QMessageBox::information(this,tr("error"),tr("%1").arg(procedure.lastError().databaseText()));

QSqlQuery procedure(DB);
procedure.prepare("call shemename.packagename.procedurename(:0,:1)");
procedure.bindValue(0, "parameter1");
procedure.bindValue(1, "parameter2");
if (!procedure.exec())
     QMessageBox::information(this,tr("error"),tr("%1").arg(procedure.lastError().databaseText()));

To copy to clipboard, switch view to plain text mode 

[deivisj]

hi, I have question. how to commit DB correctly?
do I have to do a query not active for commit? commit work without

query->finish();

query->finish();

To copy to clipboard, switch view to plain text mode 

but witch way is more correct.

thanks

[a_white]

Don't know how I missed your reply, but qDB->commit() is the best way to commit a transaction.

As an added advertisement, QOpenOCCI 2.0 will be released soon and will have many improvements

[foggy-mind]

Hi,
good thing this plug-in and I'm waiting for QOpenOCCI 2.0 release.

And want to ask one question.
In "QSqlQuery Class Reference" says that "Stored procedures that uses the return statement to return values, or return multiple result sets, are not fully supported."

Does QOpenOCCI 1.3.1.a support values return???


thanks.

[a_white]

First, QOpenOCCI is limited to what the OCI and Qt lib support. Saying that, I think you can do what you ask. Second, in the Oracle world, stored procedures never return values and functions always returns values. Small correction but people get them easily confused and we can end up talking about the wrong thing. Now to do what you want you have two cases

1) See the stored procedure example I posted earlier in this thread. This deals with non-returning calls (unless you do out binds which is allowed too)

2) Formulate your sql to like "select function_to_call(value) from dual" and then treat that as a normal sql call.

QOpenOCCI 2.0 should be out soon (yeah I know I said that a while ago) but I am waiting for OCILIB to lock in it's release. I need to make sure that two libs get along before making 2.0 official. If anyone is interested in a pre-release that can contact via souceforge and I will work something out.

[a_white]

Let me clarify something. QOpenOCCI does not support the Oracle "returning into" clause since the Qt lib does not have a good mechanism for that exchange. May be something for a future release though.

Next, array like structures are not currently supported in 1.x but will have basic support in 2.0. This will be limited to input bound variables or native non-complex types such as numbers and strings. I am currently investigating a way to tie in non-primitive Oracle types (varrays/nested-tables/objects) back though Qt.

[foggy-mind]

Ye, you are right. there is function. Sorry for stupid question.

[foggy-mind]

Hy a_white,
One more question. Does QOpenOCCI plug'in support row count??? By QT documentation it returns with function query->size(), I get -1.

the size is not supported on driver.
qDB.driver()->hasFeature(QSqlDriver::QuerySize); returns 0.

I don't want to use while(query->next()) tmp++; to get row count.
QSQlQueryModel returns not the right count, and I don't know why (

Model = new QModel(this);
	Model->setQuery(query);
	tmp = Model->rowCount();

Model = new QModel(this);
	Model->setQuery(query);
	tmp = Model->rowCount();

To copy to clipboard, switch view to plain text mode 

)

tmp = 255 in fact rows is 419

Any suggestions...
thanks.

[spirit]

btw, Qt 4.5.0 opensource already contains OCI driver.

[foggy-mind]

btw, Qt 4.5.0 opensource already contains OCI driver.

very good news

[foggy-mind]

I find the answer why QSqlQueryModel function count() returns not the real count of rows. The answer is there QSqlQueryModel::fetchMore()

And QOCI plugin don't report back the size of a query too .