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