Wednesday, September 15, 2010

SQL%NOTFOUND

Don't use this inside the for loop LIKE FOR
FOR i IN (SELECT sch_id,CURDATE FROM ORDERS)
LOOP
DON'T USE(EXIT WHEN SQL%NOTFOUND);

1 comment:

  1. Thank you so much for clearing out all the confusions that were in my mind about all these three clauses. Each of them is so neatly explained and the usage of all of them is more cleared when I executed the queries that you have shared.
    sap support package stack

    ReplyDelete