Oracle OCI Stagge
Posted: Mon Oct 26, 2009 10:19 am
Hi,
I am unable to execute two sql commands in before sql tab of Oracle_OCI stage.
For example
insert into test values('a','b');
commit;
update test set ind='Y' where ind = 'N';
commit;
But i am getting the below error :
JobTest..Oracle_OCI_0: ORA-00900: invalid SQL statement
Please let me know is it possible or execute or not. But the sql queries is perfect without syntax error. So there is no sql syntax problem
I am unable to execute two sql commands in before sql tab of Oracle_OCI stage.
For example
insert into test values('a','b');
commit;
update test set ind='Y' where ind = 'N';
commit;
But i am getting the below error :
JobTest..Oracle_OCI_0: ORA-00900: invalid SQL statement
Please let me know is it possible or execute or not. But the sql queries is perfect without syntax error. So there is no sql syntax problem