topic Re: Error exporting data from EDB into Oracle in Talend Studio

Error exporting data from EDB into Oracle

Anonymous — Sat, 16 Nov 2024 14:16:37 GMT

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

Re: Error exporting data from EDB into Oracle

Anonymous — Wed, 30 Jul 2008 03:37:19 GMT

Hello

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

shong

Re: Error exporting data from EDB into Oracle

_AnonymousUser — Fri, 21 May 2010 23:19:01 GMT

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.

Re: Error exporting data from EDB into Oracle

Anonymous — Mon, 28 Mar 2016 21:47:18 GMT

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)

Re: Error exporting data from EDB into Oracle

Anonymous — Tue, 29 Mar 2016 09:12:08 GMT

Hi krisreddy,
Could you please go to code generated tab and show us your sql statement.(marked ad red line)?
Best regards
Sabrina