You are not logged in.
Thanx for your reply.
I found the problem, and my query works now.
I had to remove the semicolon at the end of the query (in SQLBuilder) in order to make my job works, even if this semicolon was not a problem in the query builder.
There is no limitation in TOS and it can return rows when you execute the query statement in Talend SQL Builder editor.
What's your error?
I don't understand why my Oracle query returns rows in SQL*Plus, but not when I execute it from the Talend SQL Builder editor.
Is this feature limited to simple queries ? (are subqueries supported for instance ?)