Hi,

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,

Regards
Sandeep