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,
[Quoted] i need your help for this situation :
Date: Fri, 11 Sep 2009 09:15:35 -0700 (PDT)
Message-ID: <be841305-6b91-4e9a-9dee-3fa63637cf6a_at_k19g2000yqc.googlegroups.com>
Hello,
[Quoted] 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 - 18:15:35 CEST