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: IS
     5: 	PRAGMA AUTONOMOUS_TRANSACTION;
     6: 	name_id		NUMBER;
     7: BEGIN
     8: 	if ignore_null = 1 and name_in is null then
     9: 		return null;
    10: 	end if;
    11: 
    12: 	SELECT id
    13:           INTO name_id
    14:           FROM rhnPackageName
    15:          WHERE name = name_in;
    16: 
    17: 	RETURN name_id;
    18: EXCEPTION
    19:         WHEN NO_DATA_FOUND THEN
    20:             INSERT INTO rhnPackageName (id, name)
    21:                 VALUES (rhn_pkg_name_seq.nextval, name_in)
    22:                 RETURNING id INTO name_id;
    23:             COMMIT;
    24: 	RETURN name_id;
    25: END;