Crystal Reports .NET and Oracle Package with REF cursor 
Author Message
 Crystal Reports .NET and Oracle Package with REF cursor

Hi all,

Is it possible to use OLE DB - Microsoft OLEDB Provider for Oracle
with an Oracle stored package/procedure that returns a reference
cursor using VB.NET, Crystal Reports 9 and Oracle 8.1.7? I remember
reading somewhere that the Native Oracle driver and CR Oracle 8 ODBC
drivers are the only options for REF cursors.

I can design the report using the Microsoft OLEDB provider for Oracle
and can sucessfully preview the report in CR. However, running the
report from VB.NET, when I export the report to PDF I see "Failed to
open a rowset ...". With the same VB.NET code using the Native Oracle
Server driver the report is able to be exported to PDF.

The problem with the Native Oracle driver is performance. Previewing
the report in CR for 3,000 rows takes about 3 minutes. Using the
Microsoft OLEDB provider for Oracle takes about 1 minute for same
number of rows.

Another thing to note, after selecting the procedure/package from the
Database Expert, if I try to Verify Database, I always see the message
'The database table "OraclePackageName_OracleProcedureName" cannot be
found. Proceed to remove this table from the report?'

Any help is appreciated.


Sat, 24 Sep 2005 03:07:14 GMT  
 [ 1 post ] 

 Relevant Pages 

1. OLE DB with Cystal Reports .NET and Oracle package

2. Oracle Packages and Crystal Reports

3. Crystal Reports 8.5 (VB6) to Crystal Reports NET (VB.NET) conversion

4. oracle ref cursors / dropdown menu and labels

5. ADO and Oracle Ref Cursor

6. Oracle SP, ref Cursor with VB6

7. ref cursor stored procedure oracle problem rdo

8. Oracle Ref Cursor by ADO

9. get Oracle REF CURSOR using ADO

10. Return Multiple Ref Cursors from Oracle

11. Oracle REF CURSOR into ADO Recordset

12. ADO and Oracle Ref Cursor


Powered by phpBB® Forum Software