OLEDB ADO vs Oracle Server

[Former Member]

Hello,

In Crystal Reports 2013, why is it that some stored procedures are only available for consumption via OLEDB ADO connectivity and not visible at all through Oracle Server connectivity? What can be done to consume such procedures via Oracle server connectivity?

[former_member183750 · Accepted solution]

I believe the SPs should be available. But correct Oracle configuration, correct DB clients, correct CR updates all come into play.

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow me on Twitter

[former_member11696]

There is a known issue, and has been for some time now, that Oracles OLE DB Provider does not work in CR with Stored Procedures.

I found a doc related about this topic, it mentioned application could use a Boolean attribute named “PLSQLRSet” to let Oracle OLEDB connection support store procedure.

https://docs.oracle.com/cd/E51173_01/win.122/e18594/using.htm#OLEDB168

But it still fails....

Use ODBC and it should work.

We have posted to Oracle to see why it's not working and what can be enabled to make it work.

Don

[Former Member]

Thanks a ton . I am actually intending to use Oracle server connectivity as it supports Japanese charateres very well. However, the stored procedure is not available for consumption through Oracle Server connectivity. (unlike OLE-DB. See the Japanese char issue here :  http://scn.sap.com/thread/3742990 )..

Do keep me updated  on the reply from Oracle team!!

Thanks,

Prasanna