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

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