What is the issue exatly? It is just slow?? Can you give us some examples code to play with. Slowness can be caused by anything from low-ban width, poor SQL, a badly partiioned DB or just too much data??
We need to know the version of DBD::Oracle you are using as well Cheers John > Date: Tue, 17 May 2011 22:18:22 +0100 > From: tim.bu...@pobox.com > 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 -----