Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Hope everyone is doing well . I am facing an issue.I am trying to integrate multiple sql queries of Oracle in 1 toracleRow. I have already setup my toracleconnection using allowMultiQueries=true. But when I am using Multiple Queries with ";" separated by them giving ora error of sql command not properly ended. Is there any way of writing multiple queries in one Row components
Hi @Richard Hall,
I resolved the issue context to this Article
https://community.talend.com/s/article/Executing-multiple-SQL-statements-with-one-tOracleRow-component-G7XJq
Actually for DDL have to use execute immediate.
😉
You need a Begin and and End in your SQL. Follow this....
http://djugal.blogspot.com/2013/03/talend-writing-multiple-sql-queries-in.html
Hi @rhall,
I was trying with your solution.But still getting sql command not properly ended. I have tested my Oracle Connection with allowMultiQueries=true. Is there any different WayOut richard?
It might be easier to resolve if you paste your query 🙂
Try this.....
"BEGIN Create Table B as select * from A; truncate Table tableA; END"
Hi @Richard Hall,
I resolved the issue context to this Article
https://community.talend.com/s/article/Executing-multiple-SQL-statements-with-one-tOracleRow-component-G7XJq
Actually for DDL have to use execute immediate.
😉
Page is not working.
Also, I am trying to re-create sequence by Drop and Craete sequence statements, but its not working with BEGIN and END.
"BEGIN
DROP SEQUENCE SEQ1;
CREATE SEQUENCE SEQ1 MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE;
END"
Any thoughts ?
Hi @Viral Kothari,
Thanks for raising the broken link issue. We had to dynamically modify quite a bit of HTML when we migrated all of the posts from our old Community application to this new application. Some of the links got missed. I have corrected this one, so hopefully it will be of more use to you now.
Regards
Richard