LOOKUP_CHANNEL_ARCH
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_CHANNEL_ARCH(label_in IN VARCHAR2)
3: RETURN NUMBER
4: IS
5: channel_arch_id NUMBER;
6: BEGIN
7: SELECT id
8: INTO channel_arch_id
9: FROM rhnChannelArch
10: WHERE label = label_in;
11:
12: RETURN channel_arch_id;
13: EXCEPTION
14: WHEN NO_DATA_FOUND THEN
15: rhn_exception.raise_exception('channel_arch_not_found');
16: END;