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

LOOKUP_FEATURE_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_feature_type(label_in in varchar2)
     3: return number
     4: deterministic
     5: is
     6: 	feature_id number;
     7: begin
     8: 	select	id
     9: 	into	feature_id
    10: 	from  rhnFeature
    11: 	where	label = label_in;
    12: 
    13: 	return feature_id;
    14: exception
    15:         when no_data_found then
    16:             rhn_exception.raise_exception('invalid_feature');
    17: end;