1 Reply Latest reply: Feb 26, 2013 11:33 PM by jeneesh RSS

    How to update a multiple records using store procedure

    992892
      Hi i am very new to pl/sql, i want to update records which returns more than 1 row using store procedure. i tried with ref_cursor but failed to update, please help me with this its very urgent

      thanks
        • 1. Re: How to update a multiple records using store procedure
          jeneesh
          989889 wrote:
          Hi i am very new to pl/sql,
          Start learning

          2 Day Developer Guide
          All the docs
          i want to update records which returns more than 1 row using store procedure.
          Update will not RETURN any rows.. You need to explain your requirement with sample data (CREATE TABLE and INSERT statements), expected output, the logic and the db version
          i tried with ref_cursor but failed to update,
          So, you can post what have you tried also..
          please help me with this its very urgent
          It is not considered as a good forum etiquette to claim your post as an urgent one. As this is a public forum, every one is equal..