I am trying to export data from an EDB database into an Oracle table.I am encountering the below error and would aprpeciate any guidance.Thanks in advance. ------ Exception in component tOracleOutput_1 java.sql.SQLException: ORA-00907: missing right parenthesis at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:936) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1770) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1739) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:298) at dailyload.swg_dwhs_0_1.swg_dwhs.tPostgresqlInput_1Process(swg_dwhs.java:1065) connecting to socket on port 3372 connected ------ Rachana
java.sql.SQLException: ORA-00907: missing right parenthesis
The probalble cause is a left parenthesis has been entered without a closing right parenthesis, or extra information was contained in the parentheses, All parentheses must be entered in pairs. Please Correct the syntax and retry the statement.
Aslo, please go to code generated tab and show your sql statement.
Best regards
I had the same problem, so I fixed it changing the source column name : "STATE I/O" to "STATE", one hour later.... If you can´t modifiy the source column name maybe you can write a view.
I am getting this error , in tOracleInput_2 component, I verified very clearly the quotes are matching .In my case I am getting this error if I pass dates to a where condition through context variable like ( table1.date1>="+context.loaddate+") this. If I pass hard coded values in place of context query runs. Please suggest , don't throw generic replies. Exception in component tOracleInput_2 java.sql.SQLException: ORA-00907: missing right parenthesis at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:754) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:804) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1051) at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:845) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1156) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1315)
