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

LOOKUP_VIRT_SUB_LEVEL

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_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;