Hi all,
I need to call database function within in qt application. But, it fails with below error;
QOCIResult::exec: unable to execute statement: ORA-06576: not a valid function or procedure name
DB: Oracle Driver: QOCI
The Function returns record table.
C++ code: QString qs = "CALL func()"; QSqlQuery query; query.exec(qs); // this fails
Qt documentation says at QSqlQuery Class Reference:
"Stored procedures that uses the return statement to return values, or return multiple result sets, are not fully supported. For specific details see SQL Database Drivers. "
this means QOCI does not work with functions which returns parameter ????
Is there any way doing this ?
Thanks in Advance