|Applies To||RSA Product Set: Archer|
RSA Product/Service Type: Database Query Transporter Datafeed
RSA Version/Condition: 5.x, 6.x
Platform: OracleClient Data Provider
|Issue||The user receives the error message below when attempting to run the Database Query Transporter Datafeed:|
An unexpected error has occurred: ORA-00911: invalid character
This occurs even after verifying that all the values in the Transport tab are correct.
|Cause||This issue occurs when a semicolon ( ; ) is present at the end of the query statement.|
In the example above, the query that was used is shown below.
SELECT foo2 FROM foo;
|Resolution||Removing the semicolon from the end of the query statement fixes the issue, as shown in the example below:|
SELECT foo2 FROM foo