The return cursor(SYS_REFCURSOR) is too much slow

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

Quote:

---

Originally Posted by sandy_soft

There is any database parameter that i need change ?

---

Are you looking for a silver bullet like _do_it_faster=true?

What kind of application would require to do a "select *" with no predicate on the customers table? may be is time to look at database/app design before looking at backend side.