Crystal 6 and Oracle 9i stored procedures

[mrguyton]

Has anyone been able to get Crystal Reports 6 (6.0.1.151) to work with Oracle 9i (or 8i) stored procedures?

thanks,

Fred

 

[lyanch]

According to the documentation. Crystal 6 only supports up to Oracle 8.05, and then with the native driver only. I am currently developing oracle sp's so have the document URL handy.

Lisa

http://support.crystaldecisions.com/communityCS/TechnicalPapers/scr_oracle_stored_procedures.pdf

 

[mrguyton]

Thanks Lisa. Unfortunately I've seen that document. So what I'm trying to find out is if there is a way to make it work even if "unsupported". We're trying to avoid a Crystal upgrade at this point.

Fred

 

[lyanch]

One thing I can tell you that I have found is that no driver (native or ODBC from various sources) works with the 9i timestamp data type. I has to be converted at the server to work. ODBC crashes if you don't and native just shows a black 10 char string.

Lisa