Easysoft ODBC-Oracle Driver

Why do I get error "[HY000] [Easysoft][Oracle]ORA-00911: invalid character at offset xxxx" when running Crystal Reports?

Article:
00751
Last Reviewed:
2nd Januray 2024
Revision:
3

When Crystal Reports performs joins, it adds { oj sql }; to the SQL statement, e.g.:

SELECT RightTable.*, LeftTable.*
{ oj(FROM RightTable INNER JOIN LeftTable ON RightTable.RHS = LeftTable.LHS) }

The Easysoft Oracle ODBC Driver did not ignore or strip this entry thus causing the error. This was fixed in Easysoft ODBC-Oracle Driver V1.3.

Applies To

Knowledge Base Feedback

* Did this content help you?
* Please select one option based on your first choice:

(* Required Fields)