LOOKUP_XCCDF_BENCHMARK

Arguments:

Returns:

Source

Legend: comment string keyword reserved word operator

     1: function
     2: lookup_xccdf_benchmark(identifier_in in varchar2, version_in in varchar2)
     3: return number
     4: is
     5:     benchmark_id    number;
     6: begin
     7:     select id
     8:       into benchmark_id
     9:       from rhnXccdfBenchmark
    10:      where identifier = identifier_in and version = version_in;
    11:     return benchmark_id;
    12: exception when no_data_found then
    13:     begin
    14:         benchmark_id := insert_xccdf_benchmark(identifier_in, version_in);
    15:     exception when dup_val_on_index then
    16:         select id
    17:           into benchmark_id
    18:           from rhnXccdfBenchmark
    19:          where identifier = identifier_in and version = version_in;
    20:     end;
    21:     return benchmark_id;
    22: end lookup_xccdf_benchmark;