normally if I want to run multi-statement I do:
Code: Select all
var s = "BEGIN INSERT...; INSERT...; END;"
var c = new OracleCommand(s, cnn);
c.ExecuteNonQuery();
When I tried the same BEGIN DROP..; DROP..; END; approach I got
pls-00103: Encountered the symbol "DROP" when expecting one of the following...
Running it one by one is seriously bad idea. I had a lots of problem with devart in the course of 8 yrs.. I wont be surprised that its not possible.
But perhaps someone knows how to do it..