Talend community forum / [resolved] Drop table with the names from a query

Khor · 2012-05-04 10:11:54

Hi,

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?

Thanks,
Khor

pedro · 2012-05-04 10:19:32

Hi Khor

You might use tOracleTableList to retrieve tablename, tOracleRow to delete them.
The job should be as follow.
tOracleTable--iterate-->tOracleRow

Regards,
Pedro

Khor · 2012-05-04 10:22:57

Thank you pedro, I'll try what you said.

Khor · 2012-05-04 10:49:48

Pedro,

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?

Regards,
Khor

pedro · 2012-05-04 10:53:13

Hi Khor

The NPE exception means you didn't put a tOracleConnection component in your job.

You might use this expression to get table name.
((String)globalMap.get("tOracleTableList_1_CURRENT_TABLE"))

Regards,
Pedro

Khor · 2012-05-04 10:58:37

Hi pedro,

Thank you, it worked perfectly.

Best regards,
Khor

Announcement

Unanswered posts

#1 2012-05-04 10:11:54

[resolved] Drop table with the names from a query

#2 2012-05-04 10:19:32

Re: [resolved] Drop table with the names from a query

#3 2012-05-04 10:22:57

Re: [resolved] Drop table with the names from a query

#4 2012-05-04 10:49:48

Re: [resolved] Drop table with the names from a query

#5 2012-05-04 10:53:13

Re: [resolved] Drop table with the names from a query

#6 2012-05-04 10:58:37

Re: [resolved] Drop table with the names from a query

Board footer