LOOKUP_SG_TYPE
DDL scriptArguments:
Name | Data Type | Default Value | In/Out |
---|
LABEL_IN | VARCHAR2 | | IN |
Returns:
NUMBER(38)Source
Legend: 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;