Main Tables Views Materialized Views Indexes Constraints Triggers Procedures Functions Packages Sequences Java Sources Jobs Sanity Check Index DDL scrips
Arguments Source

LOOKUP_PACKAGE_KEY_TYPE

DDL script

Arguments:

NameData TypeDefault ValueIn/Out
LABEL_INVARCHAR2 IN

Returns:

NUMBER(38)

Source

Legend: comment string keyword reserved word operator
     1: function
     2: lookup_package_key_type(label_in in varchar2)
     3: return number
     4: is
     5: 	package_key_type_id number;
     6: begin
     7: 	select id into package_key_type_id from rhnPackageKeyType where label = label_in;
     8: 	return package_key_type_id;
     9: exception
    10: 	when no_data_found then
    11: 		rhn_exception.raise_exception('package_key_type_not_found');
    12: end;