Summary
The user is encountering a Java SQL exception while trying to pull data from QuickBooks to Oracle using the QB Connector Ver. 2.2.2 and Oracle Connector Ver. 0.2.0. The error message indicates an issue with a symbol ‘;’ in the SQL query.
Question
When I am attempting to pull data from QuickBooks to Oracle I get this error: (QB Connector Ver. 2.2.2, and Oracle Connector Ver. 0.2.0)
java.sql.SQLException: ORA-06550: line 3, column 1: PLS-00103: Encountered the symbol “;” when expecting one of the following: ( begin case declare end exception exit for goto if loop mod null pragma raise return select update while with <an identifier> <a double-quoted delimited-identifier> <a bind variable> << continue close current delete fetch lock insert open rollback savepoint set sql execute commit forall merge pipe purge json_exists json_value json_query json_object json_array The symbol “exit” was substituted for “;”
what can possibly be a solution
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.