How Crystal Reports 8.5 can use an Stored proc in Oracle 9i

[lorein]

Hi I need your help!!!

I make a package with one SP in oracle 9i, I take this code from an example in seagate page, and also create the table

CREATE OR REPLACE PACKAGE Test_Package
AS TYPE Test_Type IS REF CURSOR;
END Test_Package;
/

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;
/

I connect crystal rep 8.5 using native connection to Oracle and I can put this Stored procedure in the report, the problem is when I open the insert fields screen I can see the stored procedure and the fields but when I try to drop a field in the design report I cann't do it

Some body knows why????????????

thanks!!!

 

[synapsevampire]

What happens when "you can't do it", does it error?

Try the CR ODBC driver (which if you're using ODBC it should be the CR ODBC driver)

Make sure that you open the CR ODBC connection and make the selection "procedure returns results".

I've used CR 8.5 via ODBC to Oracle 9 in the past.

-k