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

LOOKUP_SERVER_ARCH

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