Oracle stored Procedure to return multiple resultsets to .net
===

Hi Im new to oracle and have written the following stored proc to return multiple data sets to my front end .net app.

    create or replace
PROCEDURE                       GET_EMPLOYEE_INFO 
(
  EMP_NO IN VARCHAR2,
  E_RECORD_SET1 OUT SYS_REFCURSOR,
  E_RECORD_SET2 OUT SYS_REFCURSOR,
  E_RECORD_SET3 OUT SYS_REFCURSOR,
  E_RECORD_SET4 OUT SYS_REFCURSOR
) AS 
BEGIN
  OPEN E_RECORD_SET1 FOR
SELECT * FROM EMP.EMPLOYEES;

  OPEN E_RECORD_SET2 FOR
SELECT * FROM EMP.CITIES;

  OPEN E_RECORD_SET3 FOR
SELECT * FROM EMP.STATES;

  OPEN E_RECORD_SET1 FOR
SELECT * FROM EMP.DURATION;

ALL THE SELECT QUERIES EXECUTE FINE, BUT WHEN I EXECUTE THE STORED PROC, IT DISPLAYS THE RECORD SETS BUT I FELL ALL THE DATA IS NOT BEING PULLED AND THE BOTTOM IT STILL SHOWS "RUNNING IDE CONNECTION"

IS THE PROC LOOPING ?
IS THERE A LIMITATION FOR SYS_REFCURSOR ?
SO I NEED TO CLOSE THESE CURSORS ?

THANKYOU FOR YOUR TIME
JUSTIN