The return cursor(SYS_REFCURSOR) is too much slow
Date: Fri, 11 Sep 2009 09:15:35 -0700 (PDT)
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
SELECT * FROM CUSTOMER But i need get this information through a function that require more than 2 MINUTES!!!
FUNCTION getCUSTOMER( ) RETURN SYS_REFCURSOR AS
BEGIN OPEN cur FOR ' SELECT * FROM CUSTOMER ';
END; There is any database parameter that i need change ?? Any suggestion, please ??
Santana Received on Fri Sep 11 2009 - 11:15:35 CDT