Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Crystal Reports and the IdiotManager(TM)
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
-- 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
![]() |
![]() |