Error pulling data from QuickBooks to Oracle with specific connectors

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.

Join the conversation on Slack

["quickbooks-connector", "oracle-connector", "java-sql-exception", "ora-06550", "pls-00103"]