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

Reply via email to