Error in tOracleInput component

vidya821 — Sat, 16 Nov 2024 09:37:24 GMT

Hi,

I am getting below error while trying to extract table content into csv file using tOracleInput component

Exception in component tOracleInput_1 (testjob)

java.sql.SQLSyntaxErrorException: ORA-00923: mot-clé FROM absent à l'emplacement prévu

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)

at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)

at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)

at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202)

at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:45)

at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:766)

at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:897)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1034)

at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1244)

at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:420)

[statistics] disconnected

at sun_project.testjob_0_1.testjob.tOracleInput_1Process(testjob.java:651)

at sun_project.testjob_0_1.testjob.runJobInTOS(testjob.java:1118)

at sun_project.testjob_0_1.testjob.main(testjob.java:884)

Below is the query fired

"select con.IDNTFR AS IDNTFR from"+context.dwschema+".contract as con where con.rownum < 10"

The database connection parameters are configured using context

Thanks.

Re: Error in tOracleInput component

cterenzi — Fri, 16 Jun 2017 18:00:49 GMT

There needs to be a space between "from" and the table name.