Article 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 |