"After an UPDATE I usually use SQL%ROWCOUNT to check or log the number of rows affected by the update.
The definition of SQL%NOTFOUND is clear, it returns:
NULL if no SELECT or DML statement has run
FALSE…"
The social network for Oracle people
-
Pradeep Tiptur Nagaraja
- Male
- San Francisco, CA
- United States
- Blog Posts
- Discussions (1)
- Events
- Groups
- Featured Photos
- Photo Albums
- Featured Videos
Pradeep Tiptur Nagaraja's Discussions
Need help on Sql%Not Found
1 Reply
After an Update statement, Sql%NotFound is being validated. Sql%NotFound validates to true even though a record matching the update condition is found. Because of this, the procedure execution Exits.…Continue
Started this discussion. Last reply by Eddie Awad Jun 29, 2012.
Gifts Received
Pradeep Tiptur Nagaraja has not received any gifts yet
Pradeep Tiptur Nagaraja's Page
Latest Activity
Pradeep Tiptur Nagaraja posted a discussionNeed help on Sql%Not Found
After an Update statement, Sql%NotFound is being validated. Sql%NotFound validates to true even though a record matching the update condition is found. Because of this, the procedure execution Exits. If the Sql%NotFound is commented, then the Record gets updated. Please help me as to any special scenario which is validating Sql%NotFound condition to True.See More
Profile Information
- About Me:
- I am a Oracle Developer with wide range of experience in Database Design, PL-SQL development and Oracle Apps.
Comment Wall
- No comments yet!
© 2013 Created by Eddie Awad.
