PDA

View Full Version : Call to database function.



retto
11th September 2009, 14:17
Hi all,

I need to call database function within in qt applications 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);

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

retto
14th September 2009, 13:29
Is anybody know this issue ?? Why anybody answers to question ?? I think this question is not hard :)

Thanks.