Symptom.
- Stored procedures missing.
- No Oracle stored procedures listed in Crystal Reports, when attempting to create a new report via an ODBC connection to Oracle using the CR Oracle ODBC driver.
- When creating a new report via an Oracle native connection, it list all the Oracle stored procedures.
Solution:
To display a list of all available Oracle stored procedure when using the following ODBC drivers to connect to Oracle:
- CR Oracle ODBC Driver
- CR Oracle Wire Protocol ODBC Driver
Uncheck the CR Oracle ODBC driver option: "Use Current Schema for SQLProcedures". To do so, follow the steps below:
1. Open the ODBC Data Source Administrator.
2. Select the ODBC DSN created using the CR Oracle ODBC Driver, and click on the button "Configure"
3. In the "ODBC Oracle Driver Setup", under the tab "Performance", uncheck the option: "Use Current Schema for SQLProcedures"
4. Click "OK" to accept the change.
Now, when creating a new report in Crystal Reports using the CR Oracle ODBC driver, it will list all the available Oracle Stored Procedures.
More details Refer Snote:1980814
EmoticonEmoticon
Note: only a member of this blog may post a comment.