Main Tables Views Materialized Views Indexes Constraints Triggers Procedures Functions Packages Sequences Java Sources Jobs Sanity Check Index DDL scrips
Arguments Source

INSERT_PACKAGE_CAPABILITY

DDL script

Arguments:

NameData TypeDefault ValueIn/Out
NAME_INVARCHAR2 IN
VERSION_INVARCHAR2 IN

Returns:

NUMBER(38)

Source

Legend: comment string keyword reserved word operator
     1: function insert_package_capability(name_in in varchar2, version_in in varchar2 default null)
     2: return number
     3: is
     4:     pragma autonomous_transaction;
     5:     name_id number;
     6: begin
     7:     insert into rhnPackageCapability (id, name, version)
     8:         values (rhn_pkg_capability_id_seq.nextval, name_in, version_in) returning id into name_id;
     9:     commit;
    10:     return name_id;
    11: end;