tOracleInput : select using dblink

[_AnonymousUser]

Hi,
I created a dblink on Oracle. I checked the dblink with a select query using that dblink. It works fine on Oracle SQL developer.
On TOS I've copy the same query (with the dblink) in a tOracleInput component. I got an error.
Then I tried to get through a view (view with the select query using the dblink) in order to avoid using the dblink syntax in the tOracleInput component. I got more or less the same error.
I finaly tried with a materialised view doing the same thing and it worked.
My question is : is it possible to use a db link in a tOracleInput component ? Do I have to use another kind of component ? (tOracleRow?) Is it a problem if the tOracleInput is connecting to a database through a tOracleConnection ?
Best regards,
CR

[Anonymous]

Hi,
For your question, when you drag your DB connection from Repository to Designer, there will poped up a Components window in which you can choose one component to create. see pic for details.
In addition that could you upload your screenshot about the error as you description

On TOS I've copy the same query (with the dblink) in a tOracleInput component. I got an error.
Then I tried to get through a view (view with the select query using the dblink) in order to avoid using the dblink syntax in the tOracleInput component. I got more or less the same error.

I have a little confusion about that, thanks a lot.
Best regards
Sabrina

[Anonymous]

Hi CR,
I think you can create functions to get data from your database link. So, because in Talend Metadata we can not get all elements in database.
Regar,
Luan