Skip to Content
0
Former Member
May 12, 2016 at 03:01 PM

How and when would I use Database Expert Connection to Oracle Server

42 Views

We have a core application that has been setup to use Oracle Provider for OLEDB. I can't get Ref Cursor (strong named or weak named) to return data with this connection.

I tried the Oracle Server connection and I'm able to return data on one of my databases using a Ref Cursor not the other. One database display the data in the viewer, the other gets failed to retrieve data from the database vendor code 6550.

I have access to Crystal Reports XI, Visual Studio 2010 or Visual Studio 2013. We have Runtime for 32 bit and 64 bit installed.

The core application won't allow us to use Microsoft OLEDB for Oracle.

Looking for options:

  • How to return data from complex stored procedure in Oracle, using the Oracle Provider for OLEDB. Does the stored procedure have to be included in the package or can it be stand alone?
  • How and when would I use Oracle Server in the Database Expert, and how would it be deployed when a Crystal Report has been created using it for the connection?
  • any other option that would allow me to retrieve data with either connection?

Thank you,

Bruce Edgar

bruce.edgar@fisglobal.com