LOOKUP_SNAPSHOT_INVALID_REASON

Arguments:

Returns:

Source

Legend: comment string keyword reserved word operator

     1: function
     2: lookup_snapshot_invalid_reason(label_in in varchar2)
     3: return number
     4: is
     5: 	snapshot_invalid_reason_id number;
     6: begin
     7:     select id
     8:       into snapshot_invalid_reason_id
     9:       from rhnsnapshotinvalidreason
    10:      where label = label_in;
    11: 
    12:     return snapshot_invalid_reason_id;
    13: exception when no_data_found then
    14:     rhn_exception.raise_exception('invalid_snapshot_invalid_reason');
    15: end;