Re: How to get Crystal Reports to access stored procedure

In article <3453B336.A239B3EF_at_rc-produktion.se>, Robert Claeson <robert_at_rc-produktion.se> writes
>Andy Hardy wrote:
>
>> I've been asked to get Crystal Reports to generate a report based on an
>> Oracle stored procedure?
>>
>> I kind of expect that the stored procedure will have to return a cursor
>> reference in the same way as I would with OO4O. However, the Crystal
>> documentation is very vague on what it expects to see.
>
>I've used Crystal 5.0 Pro with stored procedures and Sybase SQL Server. I
>just created the procedures to return a result set just like any normal
>query would. No cursors involved.
>
>--
>
>Robert Claeson
>Robert C Produktion AB - Box 20055 - S-104 60 Stockholm - Sweden
>Tel +46 8 462 30 05 - +46 708 12 41 00
>Fax +46 8 462 30 01 - +46 708 13 42 00
>E-mail robert_at_rc-produktion.se
>
>

Robert,

Unfortunately, Oracle procedures do not return results sets - in fact procedures do not need to have any SQL code within them.

Andy

-- 
Andy Hardy
Senior IT Systems Engineer
Cegelec AEG
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Opinions are mine and do not necessarily reflect those of Cegelec AEG