CE 8.5 and Stored Procedures

[baylor3217]

I have a stored procedure that takes about 20 OUT parms, runs 20 'count' sql queries and stuffs the results of each query into the appropariate OUT variable.

I want to be able to call this from crystal and display these counts, returned from the OUT parms, in my report.

This stored procedure compiles and runs just fine in SQL PLUS and TOAD, however when I go to select it in the 'Data Explorer' window in Crystal, I get an Oracle error.

1) Does this have anything to do with the fact I'm trying to use OUT parms from within Crystal in the stored proc?

2) What is the appropriate way to return data from a stored procedure in Crystal?

3) Is there any documentation on this on the next you could point me to?

 

[synapsevampire]

Yeah, CR is very particular about how it deals with Oracle SP's.

Here's the info you need, and remeber to NOT use the Oracle ODBC driver, use CR connectivity.

http://support.crystaldecisions.com/library/kbase/articles/c2001157.asp

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com