to report off a Stored Procedure, the following error
retrieve data from the database" followed by "Database Connector
Error: Cannot obtain error message from server".
Procedure being used was created using the Dynamic SQL
Dynamic SQL is
an enhanced form of Structured Query Language (SQL) that, unlike
standard (or static) SQL, facilitates the automatic generation and
execution of program statements.
Dynamic SQL does
not allow the use of Strongly Bound Ref Cursors.
To work around
this behavior, perform one of the workarounds offered below:
Use Static SQL,
in which we can have a Strongly Bound Ref Cursor e.g
Use a native
Oracle driver instead of an ODBC connection.
Failed to retrieve data from the database, Database Connector
Error, Cannot obtain error message from server, Dynamic SQL
, 5721368 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed
SAP Crystal Reports XI ; SAP Crystal Reports XI R2