LOOKUP_PACKAGE_KEY_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_package_key_type(label_in in varchar2)
3: return number
4: is
5: package_key_type_id number;
6: begin
7: select id into package_key_type_id from rhnPackageKeyType where label = label_in;
8: return package_key_type_id;
9: exception
10: when no_data_found then
11: rhn_exception.raise_exception('package_key_type_not_found');
12: end;