topic Re: tOracleRow is giving error in Talend Studio

tOracleRow is giving error

abhi90 — Sun, 16 Apr 2017 10:24:03 GMT

Hi All;

I am trying to create a Table using tOracleRow.I am trying to create Table with The Below statement

DROP TABLE TEMP_ORDERS;
CREATE Table TEMP_ORDERS AS
select a.ITEM_NAME,b.MANUFACTURER_NAME from ITEMS a
LEFT OUTER JOIN MANUFACTURERS b
ON a.MANUFACTURER_ID=b.MANUFACTURER_ID;

Now the Problem is this query is running fine sql Developer.Whereas when i am pasting this query in tOracleRow or tOracleinput it is saying that invalid char.Then I tried removing the ";" but it is saying that SQL Command not properly ended.Shong Can u help me

Re: tOracleRow is giving error

abhi90 — Sun, 16 Apr 2017 12:02:07 GMT

Anyone with any soln?

Re: tOracleRow is giving error

abhi90 — Sun, 16 Apr 2017 12:31:22 GMT

Hi Shong,xdshi;

Can you help regarding this

Re: tOracleRow is giving error

vapukov — Sun, 16 Apr 2017 15:14:26 GMT

it not understand ; as separator (/ as well)

as solution:

- for simple cases - chain of tOracleRow

- more proper - put all code in stored procedure and call it

Re: tOracleRow is giving error

cterenzi — Mon, 17 Apr 2017 14:39:37 GMT

Possibly relevant:

https://help.talend.com/display/KB/Executing+multiple+SQL+statements+with+one+tOracleRow+component

Beyond that, I seem to remember a comment that some databases need a particular setting enabled in order to issue multiple commands with one component, but cannot find the thread on the old forum.

Re: tOracleRow is giving error

vapukov — Mon, 17 Apr 2017 22:38:09 GMT

exactly!

thank You for link, I knew about BEGIN END, but it not work with DDL and I forget about EXECUTE

BEGIN
EXECUTE IMMEDIATE 'DROP TABLE TEMP_ORDERS';
EXECUTE IMMEDIATE 'CREATE Table TEMP_ORDERS AS
select a.ITEM_NAME,b.MANUFACTURER_NAME from ITEMS a
LEFT OUTER JOIN MANUFACTURERS b
ON a.MANUFACTURER_ID=b.MANUFACTURER_ID';
END;