oracle stored porocedures

[crystalhelp]

I am not an Oracle person, so it has taken me awhile to learn how creating a report based on stored procedure results differs from Sybase (thanks partly due to this website.) I now have my package, procedure and cursor created. I have added my stored procedure to the report and the Parameter Fields are automatically populated with my IN parameters. However, I would have thought my IN OUT parameter (the resultset) would be included in the Parameter Field list. How else do I report on what the stored procedure brings back? Is it a driver issue?

P.S. If you recognize this question, that is because I posted it yesterday on the CR Other Topics forum, when I probably should have posted it here. Hope that's okay.

 

[synapsevampire]

The columns returned will be in your Field Explorer under database fields, you don't have to reference the in/out cursor, Crystal does that for you.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[crystalhelp]

Thanks for the reply and it did help, but there are no fields appearing under my stored procedure. I am using the .net version and my stored procedure's cursor is weakly bound.

 

[synapsevampire]

Oracle Stored Procedures have to be designed specifically for CR, I had assumed that you'd followed their guidelines:

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

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[crystalhelp]

I have read all the guidelines, but everything I have found so far is for version 9 and under. I haven't found any guidelines for .net. I am using what I found so far and trying different things, but so far none of them have worked, but I still have more things to try. All hope isn't lost yet.