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

LOOKUP_PACKAGE_PROVIDER

DDL script

Arguments:

NameData TypeDefault ValueIn/Out
NAME_INVARCHAR2 IN

Returns:

NUMBER(38)

Source

Legend: comment string keyword reserved word operator
     1: function
     2: lookup_package_provider(name_in in varchar2)
     3: return number
     4: is
     5: 	package_provider_id number;
     6: begin
     7: 	select id into package_provider_id from rhnPackageProvider where name = name_in;
     8: 	return package_provider_id;
     9: exception
    10: 	when no_data_found then
    11: 		rhn_exception.raise_exception('package_provider_not_found');
    12: end;