tOracleRow is giving error

[abhi90]

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

[abhi90]

Anyone with any soln?

[abhi90]

Hi Shong,xdshi;

Can you help regarding this

[vapukov]

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

[cterenzi]

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.

[vapukov]

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;