Accessing REF CURSOR in Stored Procedure from Qt

[sureshbabu]

Hi,

I am trying to get array of data or cursor from a stored procedure in Oracle using Qt.

i.
CREATE TYPE NUM_ARRAY IS TABLE OF NUMBER;
CREATE OR REPLACE PROCEDURE GET_EMP_IDS(X OUT NUM_ARRAY) AS
BEGIN
SELECT ID BULK COLLECT INTO X from BKUP_EMPLOYEE;
END;

ii. RefCursor

CREATE OR REPLACE procedure GET_EMP_DETAILS(cur OUT SYS_REFCURSOR) as
begin
open cur for select * from bkupemployee;
end;

In Qt, i called QSqlQuery::execBatch(QSqlQuery::ValuesAsColumns), this execution succeeded
but iam not able to retreive the output from it.
query.boundValues(0).type returns int (zero).

Please help me in finding the solution.

Regards,
Suresh