2 Replies Latest reply on May 12, 2011 8:06 PM by 95626

    How to Multiples update using Oracle Data Provider for .NET 9.2.0.7.00

    95626
      Hi,

      I'm using Oracle Data Provider for .NET 9.2.0.7.00, I'm trying to execute several update statments in the same call, I'm trying te following:

      Update {tablename} set {fields = }.. where {rowid = x1}; Update {tablename} set {fields = }.. where {rowid = x1} ;

      "or"

      Update {tablename} set {fields = }.. where {rowid = x1};
      Update {tablename} set {fields = }.. where {rowid = x1};

      Error= Illegal character ...

      Update {tablename} set {fields = }.. where {rowid = x1}
      Update {tablename} set {fields = }.. where {rowid = x1}

      "or"

      Update {tablename} set {fields = }.. where {rowid = x1} Update {tablename} set {fields = }.. where {rowid = x1}

      Error= Statement not ended properly..

      So.. How can I do that ?

      Thanks for any help!!