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