Write Multiple Queries in toracleRow

[abhi90]

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

@rhall, @TRF, @vboppudi

[kotvir]

The correct way to write multiple SQL commnds in ORACLE (which involves Drop and Create statements) is below.

"BEGIN 

execute immediate 'DROP SEQUENCE SEQ1' ;

execute immediate 'CREATE SEQUENCE SEQ1 MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE';

END

;

"