Use cursor as Out Parameter in Stored Procedure

[morphnike]

Hi guys,
I have a serious problem.
I need to use my cursor as an out parameter, but the problem is, HOW CAN I CLOSE THE CURSOR??????

If I dont close the cursor, my server is getting really slow because of the open cursors, cause I have more than 100 stored procedures, which have a cursor as an out-parameter.

Here's one of my stored procedures :

create or replace PACKAGE pkgRes
IS
TYPE resType IS REF CURSOR RETURN res%ROWTYPE;
END pkgRes;
create or replace procedure res_sel_val
(p_id in number,cs out pkgRes.resType)
as
BEGIN
open cs for
select * from res where res_id = p_id;
--close cs;
EXCEPTION
when others then
raise_application_error(-20970, 'record kan niet geselecteerd worden');
END res_sel_val;
​

How can I close my cursor?
If I write the "close cursor" (which is in red at the code above), it returns an empty cursor, which is not my intention.

Please help me with this

Thanks in advance

Morph 'n Nike