Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Fetch and Loop in plsql

Kum KOct 23 2015 — edited Oct 25 2015

Hello,

In plsql fetch and loop, what's the difference between these 2 statements? Does it make any difference when either of the below lines take precedence over the other?

OPEN email_details_cur(p_transactionid);

    LOOP

      EXIT WHEN email_details_cur%NOTFOUND;

      FETCH email_details_cur

        INTO email_details_cur_rec;

  END LOOP;

vs

OPEN email_details_cur(p_transactionid);

    LOOP

      FETCH email_details_cur

        INTO email_details_cur_rec;

      EXIT WHEN email_details_cur%NOTFOUND;

  END LOOP;

</bod

This post has been answered by Jarkko Turpeinen on Oct 23 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 20 2015
Added on Oct 23 2015
4 comments
1,129 views