LOOKUP_PACKAGE_DELTA

Arguments:

Returns:

Source

Legend: comment string keyword reserved word operator

     1: FUNCTION
     2: LOOKUP_PACKAGE_DELTA(n_in IN VARCHAR2)
     3: RETURN NUMBER
     4: IS
     5: 	PRAGMA AUTONOMOUS_TRANSACTION;
     6: 	name_id         NUMBER;
     7: BEGIN
     8: 	SELECT id INTO name_id
     9: 	  FROM rhnPackageDelta
    10: 	 WHERE label = n_in;
    11: 
    12: 	RETURN name_id;
    13: EXCEPTION
    14: 	WHEN NO_DATA_FOUND THEN
    15: 	    INSERT INTO rhnPackageDelta (id, label)
    16: 	    VALUES (rhn_packagedelta_id_seq.nextval, n_in)
    17: 	    RETURNING id INTO name_id;
    18: 	COMMIT;
    19: 	RETURN name_id;
    20: END;