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
Bookmarks