Hi all. I'm having trouble with stored pl/sql function which returns ref cursor. This stored proc runs for 6 minutes while SQL itself executed for 6 seconds when executed outside pl/sql function.
Is there any way to speed things up without rewriting app without packages/stored procedures ? P.S. I know that DBD::Oracle 1.07 is VERY old version but unfortunately I can't update it to newest one on production server... Oracle server version is 9.2.0.6.0 Thanks in advance. -- With Best Regards, Eugene Krivdyuk