NO_DATA_FOUND EXCEPTION
From: Walter Schenk <wschenk_at_worm.hooked.net>
Date: 1995/05/07
Message-ID: <3ok1rn$e42_at_worm.hooked.net>#1/1
Date: 1995/05/07
Message-ID: <3ok1rn$e42_at_worm.hooked.net>#1/1
Jack,
Put your select statement in its own PL/SQL block. In this 'private' block, you can trap the error. If it occurs it will only roll back the work of that PL/SQL block, leaving the rest of the main block untouched. Remember that PL/SQL is a block structured language very similar to Ada. Nesting blocks can help you often with isolating what happens in one area from other areas.
Walter Schenk
SoluTech Consulting
Received on Sun May 07 1995 - 00:00:00 CEST