on Jun 14, 2016Article Content
| Article Number | 000031650 |
| 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 |