RE: Crystal Reports and the IdiotManager(TM)

From: Eberhard, Jeff <Jeff.Eberhard_at_TriumphGS.com>
Date: Mon, 10 May 2004 08:44:50 -0600
Message-ID: <86B94CDA99C77A408129A378D2DA8DB8AFCA58@compqsrv.rolls-roycegs.com>

Crystal CAN call stored procedures and retrieve rows using ref cursors. I've done with many reports and can give help if needed.

Check out:
http://support.businessobjects.com/communityCS/TechnicalPapers/scr_oracle_st ored_procedures.pdf

--Jeff

>By teh same token: it won't accept calling a stored procedure. So you
can't use the
>second line of defence, which is to write yourself the SQL and give them
just ref
>cursors. Made darn sure only they could stuff up things...
>
>Unknown to me. We can't even get it to behave on ad-hoc reports with a
database that is a
>minuscule fraction of that size... As for pre-defined reports, if you can
do it all n
>SQL then you're OK, if you need PL/SQL then you're up the proverbial
without a paddle.

>Cheers
>Nuno Souto
>in sunny Sydney, Australia
>dbvision_at_optusnet.com.au

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon May 10 2004 - 13:06:42 CDT