|Applies To||RSA Product Set: Archer|
RSA Product/Service Type: Database Query Transporter Datafeed
RSA Version/Condition: 220.127.116.11
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