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: DETERMINISTIC
     5: IS
     6: 	PRAGMA AUTONOMOUS_TRANSACTION;
     7: 	snapshot_invalid_reason_id number;
     8: BEGIN
     9: 	SELECT id
    10:           INTO snapshot_invalid_reason_id
    11:           FROM rhnSnapshotInvalidReason
    12:          WHERE label = label_in;
    13: 	RETURN snapshot_invalid_reason_id;
    14: EXCEPTION
    15:         WHEN NO_DATA_FOUND THEN
    16:             rhn_exception.raise_exception('invalid_snapshot_invalid_reason');
    17: END;