views:

135

answers:

0

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