Skip to Content

Crystal report 2008 with Oracle 11 stored procedure Performance


Wondering if this issue

Crystal report 2008 with oracle stored procedure slow reading records has solved?

As crystal report is fetching/reading only 50 record when report running with stored procedure as compare to view and table which is 500 to 1000.

I applied Crystal Service pack's one by one from SP1 to SP 2 , 3 and finaly SP4 but problem is same.

My stored procedure has REF Cursor declare with IN and OUT parameter type.

Any help will be great appreicated.

Thanks, Syed

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jun 12, 2012 at 03:09 PM

    Hi Syed,

    There have been a few cases logged where this has been noted and from all of our logging it appears Oracle is the cause of the delay. You can run CRlogger, search kbase to get and enable logging, and you'll see in CR logs there is a delay caused by Oracle just after the log on method is called.

    CR sends off a query to get the table names used in the report and that's when the delay happens.

    CR is simply waiting for a response from the Oracle Server.

    We don't know what Oracle is doing but it appears to be a permission issue on either the account you are using on the tables being accessed.

    So far no one that I know of has resolved the issue.

    Make sure you have all of the Verify Database options checked OFF in the Report, if not modify and re-publish. It helps a bit but not completely....

    If you log a case with Oracle and find a solution please share...



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.