Talend community forum / SQL Builder problem

rnddrnd2 · 2007-11-22 17:40:00

Tags: [oracle, perl, sql builder, tos2.2.1]

Hi,

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 ?)

Thanks

Regards

shong · 2007-11-23 07:54:28

Hi

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?

Best regards

shong

rnddrnd2 · 2007-11-29 18:44:43

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.

Regards

Announcement

Unanswered posts

#1 2007-11-22 17:40:00

SQL Builder problem

#2 2007-11-23 07:54:28

Re: SQL Builder problem

#3 2007-11-29 18:44:43

Re: SQL Builder problem

Board footer