INSERT_CRASH_FILE

Arguments:

Returns:

Source

Legend: comment string keyword reserved word operator

     1: function insert_crash_file(
     2:     crash_id_in in number,
     3:     filename_in in varchar2,
     4:     path_in in varchar2,
     5:     filesize_in in number)
     6: return number
     7: is
     8:     crash_file_id number;
     9: begin
    10:     insert into rhnServerCrashFile (id, crash_id, filename, path, filesize)
    11:     values (sequence_nextval('rhn_server_crash_file_id_seq'), crash_id_in, filename_in, path_in, filesize_in)
    12:     returning id into crash_file_id;
    13: 
    14:     return crash_file_id;
    15: exception when dup_val_on_index then
    16:     select id
    17:       into crash_file_id
    18:       from rhnServerCrashFile
    19:      where crash_id = crash_id_in and
    20:            filename = filename_in;
    21: 
    22:     update rhnServerCrashFile
    23:        set path = path_in,
    24:            filesize = filesize_in
    25:      where id = crash_file_id;
    26: 
    27:     return crash_id_in;
    28: end;