Re: Crystal Reports and Oracle 8

I am trying to get as far as you are already. Could you please send me a sample of the declaration for Office.OfficeNum and tell me how you told Crystal how to access this as the datasource.

PS. Info I read from Crystal said they don't support Oracle stored procedures through ODBC.

• Ron O.

In article <37C71F5C.2D2C5CB3_at_home.com>,   Madsal <softsense_at_home.com> wrote:
> Since no one at seagate software could help I've decided to take a
shot
> at this
> group for information.
>
> From an article from seagate software I have written over 50 stored
> procedures that
> will populate some 100 reports. Working fine. I am using a defined
> CURSOR type
> as a parameter:
>
> CREATE OR REPLACE PROCEDURE GetOfficeNum (AsofDate IN Date, office_cv
IN
> OUT Office.OfficeNum)
> :
> :
> :
> END;
>
> My reports work great but I am using the native Crystal driver and
need
> to go ODBC. ODBC
> will not except the cursor type. I realize this is sort of not the
> forum to discuss this
> but has anyone used Crystal report and oracle that may have a better
> solution to writing
> these reports and using the VB Crystal OCX With them.
>
> Thanks for you support
> SAM
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Sep 17 1999 - 16:22:33 CDT