SAP Knowledge Base Article - Public

1205791 - Error: "Database Connector Error: 'HY000:[Oracle][ODBC][Ora]ORA-24338: statement handle not executed" in Crystal Reports XI

Symptom

An Oracle stored procedure uses Oracle 9.2 client against Oracle 8.1 server. A Crystal report created off it works correctly in Crystal Reports 8 but in Crystal Reports XI, the following error message appears:

"Database Connector Error: HY000:[Oracle][ODBC][Ora]ORA-24338: statement handle not executed
[Database Vendor Code: 24338 ]"

Cause

The computer does not have the DataDirect Oracle Oracle 5.0 driver installed.

Resolution

To install the DataDirect Oracle 5.0 driver

  1. Go to the Downloads area of our web site.
  2. Click the Version XI link then click the I Accept link then click the Crystal Reports link.
  3. Click the Download Windows DataDirect ODBC 5.0 Drivers - all languages link.
  4. Click the Oracle drivers (only for Windows) option button and the operating system option buttons in the next two sections. Click the Submit button.
  5. Click the Download Windows DataDirect ODBC 5.0 Drivers - all languages link to download the drivers.
  6. Click setup.exe and follow the steps to install the driver.
  7. Create a DSN in the ODBC Data Source Administrator (Start > Settings > Control Panel > Administrative Tools > Data Sources (ODBC)). In the Oracle ODBC Driver Setup dialog box, click the Advanced tab.
  8. Select the Procedure Return Results check box. In Crystal Reports XI, on the File menu, click Options.
  9. On the Database tab, click Stored Procedure.
  10. In the Owner LIKE: text box, add the name of the user to explicitly tell Crystal Reports to look for that owner's schema.

Keywords

Database Connector Error, Database Vendor Code, Statement handle not executed , 8719066 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed

Product

SAP Crystal Reports XI ; SAP Crystal Reports XI R2