When we working with PLSQL statements some common errors will raise.In this one of the common Error in PLSQL is " data not found" .It will arise when there is no particular field in table. Here i will shown an example how to prevent the exception when a record is not found in PLSQL code.
Example:
The above example give an error because of the record"Address" is not found.So for this we have to get the count of records then using the condition we will execute the PL/SQL code
Example:
select Id,Name, Address from Details where Address = City.Address;Solution:
The above example give an error because of the record"Address" is not found.So for this we have to get the count of records then using the condition we will execute the PL/SQL code
select count(1) into testcount from Details where Address=city.Address; if testcount>0 then select Id,Name, Address from Details where Address = City.Address; end if;R3MQ7XNAWTMR
No comments:
Post a Comment