You are not logged in.
I have a query in a tOracleInput that returns all the tables in the database like 'XXX_' and I have to delete this tables from the database. Can anyone tell me how to achieve this?
You might use tOracleTableList to retrieve tablename, tOracleRow to delete them.
The job should be as follow.
I have two problems:
I get a nullPointerException in the tOracleTableList component.
And how can I get the table name from tOracleTableList in the tOraclerow component?
The NPE exception means you didn't put a tOracleConnection component in your job.
You might use this expression to get table name.