My question is can this .net provider support multi-statement update(batch update)? I tried with the beta .net provider,the answer was not. And my statement is update tablea set xxxx where xxx ; update tableb set xxx where xxx; It return the error message indicated that ";" was not allowed. And the SqlClient OracleClient support this; the SqlClient is: update tablea set xxxx where xxx ; update tableb set xxx where xxx; the oracleClient is : Begin update tablea set xxxx where xxx ; update tableb set xxx where xxx; End
wildfish wrote: > My question is can this .net provider support multi-statement > update(batch update)? I tried with the beta .net provider,the answer > was not. > And my statement is > update tablea set xxxx where xxx ; update tableb set xxx where > xxx; > It return the error message indicated that ";" was not allowed. > > And the SqlClient OracleClient support this; > the SqlClient is: > update tablea set xxxx where xxx ; update tableb set xxx where > xxx; > > the oracleClient is : > Begin update tablea set xxxx where xxx ; update tableb set xxx > where xxx; End > You do not need the ; to indicate the SQL continues on to the next line.
thanks a lot.I will try it on monday:)