Oracle OCI Stagge

[nanthakumar_v]

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

[sachin1]

Yes i am also getting the same error, but the single statement executes fine, so what should be the seperator between two statement to work fine in before sql of oracle OCI.

[Sathishkumarins]

Oracle OCI Stage supports multiple queries in before as well as in after stage. You can even remove COMMIT bcoz it is available as default.
The seperator is also fine. Can u provide the metadata for Test table?

Please check whether all the queries which u gave in that OCI Stage works fine or not.

[ray.wurlod]

I have a vague memory that you need double semi-colons. (;;)

[chulett]

It should work with either. The difference from what I recall is whether they run all in one session or indivual sessions. Right, here we go:

Each SQL statement is executed as a separate transaction if the statement separator is a double semi-colon ( ;; ). All SQL statements are executed in a single transaction if a semi-colon ( ; ) is the separator.