2 Replies Latest reply: May 12, 2011 3:06 PM by 95626 RSS

    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!!