GET_HW_INFO_AS_CLOB

Arguments:

Returns:

Source

Legend: comment string keyword reserved word operator

     1: function get_hw_info_as_clob(
     2: 	sid in rhnserver.id%TYPE,
     3: 	separator in varchar
     4: )
     5: return clob
     6: is
     7: 	ret clob;
     8: 	tmp varchar2(4000);
     9: begin
    10: 	dbms_lob.createtemporary(ret, true);
    11: 	for rec in (
    12: 		select m
    13: 		from (
    14:                         select 1 n, sum(nrcpu) || ' CPUs ' || coalesce(to_char(sum(nrsocket)), 'unknown') || ' Sockets' m
    15: 			from rhncpu where rhncpu.server_id = sid
    16: 			union all
    17: 			select 2, ni.name||' '||na4.address||'/'||na4.netmask||' '||ni.hw_addr val
    18: 			from rhnservernetinterface ni,
    19: 			     rhnServerNetAddress4 na4
    20: 			where ni.server_id = sid
    21: 			  and ni.id = na4.interface_id
    22: 			)
    23: 		order by n, m
    24: 		) loop
    25: 		if dbms_lob.getlength(ret) > 0 then
    26: 			dbms_lob.writeappend(ret, length(separator), separator);
    27: 		end if;
    28: 		dbms_lob.writeappend(ret, length(rec.m), rec.m);
    29: 	end loop;
    30: 	return ret;
    31: end;