LOOKUP_PACKAGE_DELTA
DDL scriptArguments:
Name | Data Type | Default Value | In/Out |
---|
N_IN | VARCHAR2 | | IN |
Returns:
NUMBER(38)Source
Legend: string keyword reserved word operator
1: function
2: lookup_package_delta(n_in in varchar2)
3: return number
4: is
5: name_id number;
6: begin
7: select id
8: into name_id
9: from rhnpackagedelta
10: where label = n_in;
11:
12: return name_id;
13: exception when no_data_found then
14: begin
15: name_id := insert_package_delta(n_in);
16: exception when dup_val_on_index then
17: select id
18: into name_id
19: from rhnPackageDelta
20: where label = n_in;
21: end;
22: return name_id;
23: end;