LOOKUP_CLIENT_CAPABILITY

Arguments:

Returns:

Source

Legend: comment string keyword reserved word operator

     1: FUNCTION
     2: LOOKUP_CLIENT_CAPABILITY(name_in IN VARCHAR2)
     3: RETURN NUMBER
     4: DETERMINISTIC
     5: IS
     6: 	PRAGMA AUTONOMOUS_TRANSACTION;
     7: 	cap_name_id		NUMBER;
     8: BEGIN
     9: 	SELECT id
    10:           INTO cap_name_id
    11:           FROM rhnClientCapabilityName
    12:          WHERE name = name_in;
    13: 	RETURN cap_name_id;
    14: EXCEPTION
    15:         WHEN NO_DATA_FOUND THEN
    16:             INSERT INTO rhnClientCapabilityName (id, name)
    17:                 VALUES (rhn_client_capname_id_seq.nextval, name_in)
    18:                 RETURNING id INTO cap_name_id;
    19:             COMMIT;
    20: 	RETURN cap_name_id;
    21: END;