Oracle DB Drivers for Crystal Reports with .Net 2008
I am using Embedded Crystal Reports with .Net 2008 (Crystal Reports Basic).
I have created a stored procedure in Oracle which is returing a REF Cursor as a result dataset. When i am trying to pull this Stored Proc from Oracle to Crystal Reports, it is throwing the below error.
Crystal Reports ActiveX Designer
Query Engine Error: '42000:[Microsoft][ODBC driver for Oracle]Syntax error or access violation'
Please help me in resolving this error.
Note: I am using Microsoft ODBC Driver for Oracle and created a DSN to connect to Crytal Reports.