|
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|