OWA_UTIL Get REMOTE_ADDR

select 
    owa_util.get_cgi_env('REMOTE_ADDR') 
from dual

PL/SQL OWA_UTIL Get REMOTE_ADDR

begin
    htp.p( SYS.OWA_UTIL.GET_CGI_ENV('REMOTE_ADDR') );
end;

ORDS Module, Template and Handler

BEGIN
    -- ORDS enable schema if applicable
--    ords.enable_schema(
--        p_enabled              => true,
--        p_schema               => '<schema_name>',
--        p_url_mapping_type     => 'BASE_PATH',
--        p_url_mapping_pattern  => '<url_pattern>',
--        p_auto_rest_auth       => true
--    );

    ords.define_module(
        p_module_name     => 'owa_util_test/',
        p_base_path       => '/owa_util_test/',
        p_items_per_page  => 25,
        p_status          => 'PUBLISHED',
        p_comments        => NULL
    );

    ords.define_template(
        p_module_name  => 'owa_util_test/',
        p_pattern      => 'img_test/',
        p_priority     => 0,
        p_etag_type    => 'HASH',
        p_etag_query   => NULL,
        p_comments     => NULL
    );

    ords.define_handler(
        p_module_name     => 'owa_util_test/',
        p_pattern         => 'img_test/',
        p_method          => 'GET',
        p_source_type     => 'resource/lob',
        p_items_per_page  => 0,
        p_mimes_allowed   => '',
        p_comments        => NULL,
        p_source          => 'select
    ''image/png'',
    null
from dual
where owa_util.get_cgi_env(''REMOTE_ADDR'') is not null'
    );

    COMMIT;
END;