Don't use dynamic queries? You can use PL/SQL variables directly in the SQL statement w/o specifying them as bind variables. That is, pass them as parameters to your stored procedure, then just put them directly in the SQL without decoration. Return XML CLOB instead of cursor?
Just some ideas. Would need to see code to know what to suggest next. I am not proposing that my solution is any faster, just different. John -----Original Message----- From: Tim Bunce [mailto:tim.bu...@pobox.com] Sent: Tuesday, May 17, 2011 2:18 PM To: dbi-users@perl.org Cc: jaha...@idexcel.com Subject: (Fwd) Re: DBD::Oracle Slow cursors ----- 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 -----
