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

LOOKUP_CF_STATE

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_cf_state(
     3: 	label_in in varchar2
     4: ) return number deterministic
     5: is
     6: 	state_id number;
     7: begin
     8: 	select	id
     9: 	into	state_id
    10: 	from	rhnConfigFileState
    11: 	where	label = label_in;
    12: 
    13: 	return state_id;
    14: end;