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@xxxxxxxxxxxxxxx ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------