[resolved] Delete Rows from an Oracle Table

One Star

[resolved] Delete Rows from an Oracle Table

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

Accepted Solutions
One Star

Re: [resolved] Delete Rows from an Oracle Table

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

All Replies
One Star

Re: [resolved] Delete Rows from an Oracle Table

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
One Star

Re: [resolved] Delete Rows from an Oracle Table

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.
One Star

Re: [resolved] Delete Rows from an Oracle Table

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

Re: [resolved] Delete Rows from an Oracle Table

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