Crystal reports is stuffing my CPU

Dear All

This may be a touch off topic but if anybody knows the answer to this problem it'll be one of the list members. I have Crystal reports 6 running via a web server and the OCX browser plug in connecting to Oracle 8.1.6 on NT via ODBC. Every time the report is run it submits the SQL to the database server repeatedly until the browser has displayed the full report. This is not a problem when only 1 day's worth of data from our system is displayed but when you get to 1 month's worth of data Crystal re-submits the SQL every 2-3 seconds for up to 15 minute? CPU utilisation goes through the roof and the rest of the system suffers as a result. When I run the SQL from SQL*Plus it starts returning data after 10-15 seconds and server CPU goes back to "idling".

So does anybody know of a Crystal parameter thjat might be encouraging it to re-run the SQL ad infinitum?

Many thanks

Tim

-----Original Message-----
From: Malyk Michael [mailto:malik_at_isettle.com] Sent: 13 December 2000 15:41
To: Multiple recipients of list ORACLE-L Subject: Re: cursor

Hi Kiam.
You can view the result from out parameter (ref cursor) from PL/SQL procedure using
SQL*PLUS for instance:
1) create variable of type "refcorsor";

      var abc refcursor;
2) assign this variable to respective output parameter;

    begin <name procedure>(....,:abc); end; 3) print the value of this variable on the screen;

    print abc;

For function the step 2 a little bit changes; :abc=<name function>(<list of parameters>);

Hope this help.
Good luck.

Michael Malyk
Oracle Programmer

"Kiam Lun (IT-HO)" wrote:

> Dear All
>
> I have out parameters as ref cursor type in a procedure.
> And I want see the result from that parameters.
> How can I do that from oracle not from client application?
>
> Thanks
>
> Alun
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kiam Lun (IT-HO)
> INET: Kiamlun_at_japfacomfeed.co.id
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Malyk Michael
  INET: malik_at_isettle.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may