| Name | Data Type | Default Value | In/Out |
|---|---|---|---|
| LABEL_IN | VARCHAR2 | IN |
Legend: comment string keyword reserved word operator
1: function
2: lookup_arch_type(label_in in varchar2)
3: return number
4: deterministic
5: is
6: arch_type_id number;
7: begin
8: select id into arch_type_id from rhnArchType where label = label_in;
9: return arch_type_id;
10: exception
11: when no_data_found then
12: rhn_exception.raise_exception('arch_type_not_found');
13: end;