Skip to Content
0
Former Member
Jul 18, 2008 at 05:58 PM

Running query in Oracle Stored Procedure is much slower than as a command

610 Views

I have a query that I set up as cursor in a stored procedure that takes 30+ minutes to return results. If I do not use a SP I get the same result set back in less than a minute. The SP starts returning data quickly but takes the 30+ minutes to finish.

Does anyone know why I may be having problems?

I am using a native connection. I was going to try it with a CR ODBC driver but when I do it does not list stored procedures to choose from. That is another question to be answered :).

I looked at this KB document, 1181947, but is seems to refer to an old Business Objects link that does not work.

Please help.