Re: Oracle with Crystal Reports 11.5.3

Try using a ref cursor defined with a sys_refcursor definition..

"Jer" <jer006_at_gmail.com> wrote in message news:e74287b9-684c-4c43-b1f4-f8c8924685c9_at_a1g2000hsb.googlegroups.com...
> Thank you Dan, looks like a lot of great information there.
>
> For the strong typed ref cursors do they also have to be of a table or
> view rowtype (I noticed that defining a record type does not work with
> crystal)?
>
> After working with SQL Server and crystal it seems a bit overkill to
> have to create a separate empty table (or view) which looks like the
> return result of the stored procedure if my procedure is selecting
> multiple fields from multiple tables...
>
> I also noticed that Crystal reports has issues finding stored
> procedures which are part of a package - it will find them initially
> but when you verify the database it removes the call - I was able to
> get around this by creating a stored procedure which was not part of
> any package!
>
> Thanks
Received on Thu Jul 10 2008 - 19:42:44 CDT