1537331 - Database Connector Error: 'ORA-24338: statement handle not executed [Database vendor code: 24338] after Verifying Database.

Verify Database operation fails with an error message:

Database Connector Error: 'ORA-24338: statement handle not executed [Database vendor code: 24338]

• Crystal Reports XI R2
• Oracle 10g

1.  Create a report based off an Oracle procedure that accepts parameters.

2.  Create parameters in Crystal Reports in any order other than the Oracle procedure parameters are defined.

(e.g. If Oracle procedure accepts the parameters as a, b, c then create the parameters in Crystal Reports in an order as b, c, a).

This happens because the Oracle procedure expects the parameter in a particular order. Whereas Crystal Reports pass the parameter values to the Oracle procedure in the order in which the parameters are created.

1.  Open the report in Crystal Reports designer.

2.  Right click on "Parameter Fields" in "Field Explorer".

3.  Select "Set Parameter Order...".

4.  Set the parameters in an order in which they are passed to the database procedure.

Verify Database fails, Database Connector Error: 'ORA-24338: statement handle not executed. , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem