Hi,
Ho to handle no data found.. can it be solved with by using NVL, i mean can we avoid a NO DATA FOUND by using an NVL in the select stmnt in the PL/SQL block

------------------------------------------------------------------------------------------------------------
Adventure, Play, Alive, Fast, Race, Addict, React, Attack, Heat, Aggression, Blast, Ahead, Escape, Challenge, Anarchy, Game, Real, Damage, Insane, Acclerate,Passion, Fear, Dominate, Crazy, Awesome, Sweat, Habit, Avenge, Balls, Imagine, Viril, Chaos, Amuse, Heavy, Panic, @#!%, Fanatic

__________________
------------------------------------------------------------------------------------------------------------
<b><i>Adventure, Play, Alive, Fast, Race, Addict, React, Attack, Heat, Aggression, Blast, Ahead, Escape, Challenge, Anarchy, Game, Real, Damage, Insane, Acclerate,Passion, Fear, Dominate, Crazy, Awesome, Sweat, Habit, Avenge, Balls, Imagine, Viril, Chaos, Amuse, Heavy, Panic, @#!%, Fanatic </i></b>

Hi,
  If you are at PL/SQL block then you can use the Exception handling. Either you can use predefined exception NO_DATA_FOUND or you can use user defined exceptions.

If your Query is simple then try to use NVL function.

Regards
S. Adalarasu
Wipro