Oracle Connector Stage Parameter Issue

jagadam · Post by **jagadam** » Mon Mar 07, 2011 3:36 pm

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

kumar444 · Post by **kumar444** » Mon Mar 07, 2011 4:44 pm

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.

kumar444 · Post by **kumar444** » Mon Mar 07, 2011 4:50 pm

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

jagadam · Post by **jagadam** » Mon Mar 07, 2011 5:00 pm

Thanks so much. It worked.

ray.wurlod · Post by **ray.wurlod** » Mon Mar 07, 2011 6:41 pm

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.

kumar444 · Post by **kumar444** » Mon Mar 07, 2011 8:28 pm

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.

ray.wurlod · Post by **ray.wurlod** » Mon Mar 07, 2011 8:42 pm

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