Hi

I am working on a reporting tool that extracts data from Oracle Stored Procedures base and generates reports using Jasper. Please find below a sample of the procedure written.

--Creating Object
CREATE OR REPLACE TYPE my_row_type AS OBJECT
(
acid varchar2(10),
foracid varchar2(20),
schm_type varchar2(5),
clr_bal_amt number,
complex number
);
/
--Creating Type
CREATE OR REPLACE TYPE my_tab_type IS TABLE OF my_row_type;
/
--Creating Package
CREATE OR REPLACE PACKAGE types AS
TYPE cursor_type IS REF CURSOR;
END Types;
/
CREATE OR REPLACE
PROCEDURE GetComplexEmpRS (p_solid IN tbaadm.gam.sol_id%TYPE,
p_recordset OUT types.cursor_type) AS
v_tab my_tab_type := my_tab_type();
BEGIN

-- Populate PL/SQL table.
FOR cur_row IN (SELECT acid,foracid,schm_type,clr_bal_amt FROM tbaadm.gam WHERE rownum<3 and sol_id = p_solid) LOOP
v_tab.extend;
v_tab(v_tab.Last) := my_row_type(cur_row.acid, cur_row.foracid, cur_row.schm_type,cur_row.clr_bal_amt,NULL);
END LOOP;

-- Do complex processing that can't be done from SQL alone.
FOR cur_row IN 1 .. v_tab.count LOOP
v_tab(cur_row).complex := v_tab(cur_row).clr_bal_amt;
END LOOP;

-- Open REF CURSOR for outout.
OPEN p_recordset FOR
SELECT acid,
foracid,
schm_type,
clr_bal_amt,
complex
FROM TABLE(CAST(v_tab As my_tab_type))
ORDER BY acid;
END GetComplexEmpRS;
/

By using the TYPE as object is table would there be any issues regarding to the performance on execution of these procedures. All reports are written in the same manner. Kindly advise.

Regards
Rathish MK