Stored Procedures

Hi,

Could anyone please give me a hand with connecting to Oracle stored procedures from Crystal Reports.

Basically, I have managed connecting to a simple stored procedure that reads the data from one single table using a parameter. But how can one connect to a stored procedure that uses more than one table?

This is a sample I have found that works fine for connecting to one single table.

# Creating the package

CREATE OR REPLACE PACKAGE Test_Package
AS TYPE Test_Type IS REF CURSOR RETURN Test_Table%ROWTYPE END Test_Package;
/

# Creating the stored procedure

CREATE OR REPLACE PROCEDURE Test_Procedure (

        Test_Cursor IN OUT Test_Package.Test_Type,
        Test_Parameter IN Test_Table.ID%TYPE)
AS
        BEGIN
                OPEN TEST_Cursor FOR
                        SELECT *
                        FROM Test_Table
                        WHERE Test_Table.ID = Test_Parameter;
        END Test_Procedure;

However, I can't say I have fully understood the above code but it performs without any problems. Can anyone shed some light on using Crystal Reports with an Oracle stored procedure reading of more than one table please?

I am on Oracle 8.1.7, Crystal Reports 8.5 developer, use ODBC with Crystal's driver (CR Oracle8 v3.6), running Win 2000.

Can all posts to this go via the newsgroups rather than my email address please.

Many thanks!
Mike Received on Mon Aug 20 2001 - 05:21:25 CDT