topic Re: [resolved] Delete Rows from an Oracle Table in Talend Studio

[resolved] Delete Rows from an Oracle Table

_AnonymousUser — Sat, 16 Nov 2024 12:56:06 GMT

Hi
I'd like to delete some rows from a table as part of my job. i.e.
delete from ADMISSIONS_STAGING.SMHPROGRAM where ATHENA_PROGRAMME_CODE is NULL;
Anyone got any idea the easiest way of doing this (in Talend)
Thanks
Steve

Re: [resolved] Delete Rows from an Oracle Table

Anonymous — Mon, 09 May 2011 11:28:34 GMT

Hello,
you could use the component tXXXRow that works with no output. (where XXX depends on your database connection; ie tMSSqlRow for Microsoft SQL Server ...)
JNB

Re: [resolved] Delete Rows from an Oracle Table

_AnonymousUser — Mon, 09 May 2011 11:56:38 GMT

Hi
Good idea but I get errors;
Exception in component tOracleInput_1
java.sql.SQLSyntaxErrorException: ORA-00911: invalid character
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
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:1034)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:942)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1377)
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:387)
at training_sh.p_0_1.P.tOracleInput_1Process(P.java:246)
at training_sh.p_0_1.P.runJobInTOS(P.java:475)
at training_sh.p_0_1.P.main(P.java:346)
disconnected
Job P ended at 11:54 09/05/2011.

Re: [resolved] Delete Rows from an Oracle Table

_AnonymousUser — Mon, 09 May 2011 12:22:02 GMT

Never mind, just being stupid.....It works fine thanks

Re: [resolved] Delete Rows from an Oracle Table

Anonymous — Mon, 09 May 2011 12:34:26 GMT

Hi,
maybe you should set the table schema, press Guess Query to get a sample and use the SqlBuilder to modify and test your statement.

JNB