This discussion is archived
1 Reply Latest reply: Feb 26, 2013 9:33 PM by jeneesh RSS

How to update a multiple records using store procedure

992892 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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..

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points