SAP Knowledge Base Article - Public

2181057 - Oracle Procedure Synonym with JDBC

Symptom

  • Synonyms do not work with Oracle Stored Procedures and JDBC driver. The same synomym works with Native connection.
  • Unable to expand Synonym for Oracle stored procedure in Field Explorer of Crystal Report using jdbc connectivity.

      Synonym.JPG

Environment

  • SAP Crystal Reports 2011
  • Oracle 11g

Reproducing the Issue

  1. Create a stored procedure named RPT_TEST_PROC in SYSTEM schema. 
  2. Create synonym named SYNONYM123 in SCOTT schema for the stored procedure RPT_TEST_PROC.
  3. Create Crystal report using jdbc connectivity to add SYNONYM123.
  4. Once the SYNONYM123 is added to the report, in the Field Explorer, SYNONYM123 cannot be expanded to access the stored procedure RPT_TEST_PROC.

Cause

Synonym of stored procedure is not supported with Oracle JDBC driver.

Resolution

Use alternative connection, like Native driver or ODBC.

Keywords

CR, Oracle, synonym, stored procedure, jdbc , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports 2011