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