The return cursor(SYS_REFCURSOR) is too much slow

From: Santana <paulito.santana_at_gmail.com>
Date: Fri, 11 Sep 2009 09:15:35 -0700 (PDT)
Message-ID: <be841305-6b91-4e9a-9dee-3fa63637cf6a_at_k19g2000yqc.googlegroups.com>



Hello,
i need your help for this situation :

I have a table :"CUSTOMER" with two thousand of records, the required time to retrieve this information with a query is less than 2 seconds :
SELECT * FROM CUSTOMER But i need get this information through a function that require more than 2 MINUTES!!!

  FUNCTION getCUSTOMER( ) RETURN SYS_REFCURSOR AS

          CUR SYS_REFCURSOR;
  BEGIN    OPEN cur FOR ' SELECT * FROM CUSTOMER ';

   RETURN cur;
  END;  There is any database parameter that i need change ?? Any suggestion, please ??

 Regards,
 Santana Received on Fri Sep 11 2009 - 11:15:35 CDT

Original text of this message