Can we use a globalMap variable as table name in tOraclOutput?

One Star

Can we use a globalMap variable as table name in tOraclOutput?

Hi,
I am passing two variables from one job to other, one is filename to a tFileInputDelimited component and the other is table name to tOracleOutput component. File name is picked correctly but its throwing an error as invalid table name.
Can we use a globalMap variable in table(table name) field in tOraclOutput component?
Please find the details in the attached images.
Regards,
Babu.
One Star

Re: Can we use a globalMap variable as table name in tOraclOutput?

Yes it's possible. You've the right steps.Your job does not work ?
One Star

Re: Can we use a globalMap variable as table name in tOraclOutput?

Hi shalouf,
Nope. Job is throwing an error as "ORA-00903: invalid table name".
When i print the table name then its printing fine but while using that variable name in context.tableName then its throwing the error.
Thanks and Regards,
Babu.

Re: Can we use a globalMap variable as table name in tOraclOutput?

You may be able to debug this issue by looking though the code tab. The base insert statement is built in the begin section of the output code. remember you can inject code-- try putting this as your table name and seeing what gets printed:
context.table_name;System.out.println(tableName_tOracleOutput_1);

From the looks of it, you are doing everything right. double check the table name-- one possibility could be that it was created case-sensitive and your context var is not the correct case.