LOOKUP_PACKAGE_NAME

Arguments:

Returns:

Source

Legend: comment string keyword reserved word operator

     1: FUNCTION
     2: LOOKUP_PACKAGE_NAME(name_in IN VARCHAR2, ignore_null in number := 0)
     3: RETURN NUMBER
     4: DETERMINISTIC
     5: IS
     6: 	PRAGMA AUTONOMOUS_TRANSACTION;
     7: 	name_id		NUMBER;
     8: BEGIN
     9: 	if ignore_null = 1 and name_in is null then
    10: 		return null;
    11: 	end if;
    12: 	SELECT id
    13:           INTO name_id
    14:           FROM rhnPackageName
    15:          WHERE name = name_in;
    16: 	RETURN name_id;
    17: EXCEPTION
    18:         WHEN NO_DATA_FOUND THEN
    19:             INSERT INTO rhnPackageName (id, name)
    20:                 VALUES (rhn_pkg_name_seq.nextval, name_in)
    21:                 RETURNING id INTO name_id;
    22:             COMMIT;
    23: 	RETURN name_id;
    24: END;