On 17/05/2011 22:18, Tim Bunce wrote:
----- Forwarded message from P S Jameel Ahamed<jaha...@idexcel.com> -----Date: Tue, 17 May 2011 16:11:04 +0100 From: P S Jameel Ahamed<jaha...@idexcel.com> To: tim.bu...@pobox.com Subject: Re: DBD::Oracle Slow cursors X-Mailer: Microsoft Office Outlook 11 HI Tim, We are facing huge issues with the SYS_refcurors of oracle 10G when returning from Stored procedure. Is there any solution you found for the issue? Many Thanks in Advance Regards P S Jameel Ahamed Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message ----- End forwarded message -----
We use reference cursors all the time and don't see any particular issues with them other than the SQL Developer report showing reused cursors which can be easily avoided. To be honest, our user space code in Perl has no select access to anything in the database and can only access tables via functions returning system reference cursors.
I wonder about your statement "when returning from Stored procedure" as procedures don't return values other than as out parameters.
Older versions of DBD::Oracle failed to inherit the rowcachesize and ora_auto_lobs which we have had problems with in the past but these are all resolved in the latest DBD::Oracle.
I guess you'd need to be more specific for anyone to help or we are just guessing.
Martin
