Five Stars

tOracleRow is giving error

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 meCapture.JPGCapture1.JPG

5 REPLIES
Five Stars

Re: tOracleRow is giving error

Anyone with any soln?

Five Stars

Re: tOracleRow is giving error

Hi Shong,xdshi;

 

Can you help regarding this

Ten Stars

Re: tOracleRow is giving error

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

-----------
Ten Stars

Re: tOracleRow is giving error

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.

Ten Stars

Re: tOracleRow is giving error

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;
-----------