ok let me try this again (clarification) [message #9351] |
Wed, 05 November 2003 12:21 |
Andy G
Messages: 25 Registered: May 2003
|
Junior Member |
|
|
Sorry I'll try to make this clearer on my part.
Maybe if I would have showed the full example of what I was trying to accomplish. If the data is not found (through my exception) im setting the stat_message to read ID Does not exist...if it is foudn I want to verify that it is active through the the stat_type_code which would be = 1 ..if it were not active it would be another value...
thanks
Begin
Select stat_type_code
Into v_stat_type
from stat_v
where v_serial_id = serial_id;
Exception
when no_data_found then
v_message := 'ID Does not exist';
If v_stat_type = 1
then v_message := 'active'
else v_message := 'Not Active'
end if';
update raw_table set stat_message = v_message
where v_serial_id = serial_id;
end;
|
|
|
|