DSXchange

Hi,

We have 2 parameters defined for schema and table under project level. I am using oracle connector stage but unable to pass two parameters like #schema#.#Table# for Table name option in properties. It's accepting only one parameter.

Could anyone let me know how to pass 2 parameters in oracle connector stage. Is it possible to pass?

Thanks

Just type in manually as #schema#.#table_name#
Do not use drop down list of use job parameter in the connector stage for this kind of issues.

Or elae you can type the same in the note pad, copy and paste in the connector's table name option.

Thanks so much. It worked.

It appears that ALL Connector stage types with database connectivity exhibit this behaviour. I am seeing the same in the ODBC Connector stage in version 8.5. Methinks an enhancement request is in order.

Select * from table_name@dblink;

The above statement is invalid in the connector stage. It should be as below

select * from table_name @dblink;

We should allow a space between table_name and @dblink in the Oracle connector.
Either ways is valid in Oracle EE stage.

None of which addresses the question of using more than one parameter reference in the SQL statement.