ADD_WEB_ENTRY_POINT Procedure

Purpose

Add a public procedure to the list of allowed objects that can be called via the URL.

The parsing schema (such as APEX_PUBLIC_USER) must have privileges to execute the procedure. You must enable EXECUTE to PUBLIC or the parsing schema.

Syntax

APEX_INSTANCE_ADMIN.ADD_WEB_ENTRY_POINT (
    p_name    IN VARCHAR2,
    p_methods IN VARCHAR2 DEFAULT 'GET' );

Parameters

Parameter	Description
p_name	The procedure name, prefixed by package name and schema, unless a public synonym exists.
p_methods (deprecated)	<div class="infoboxnote" id="GUID-F72BC668-2818-4037-9234-E4403D6FB981__GUID-91DE2E93-C953-47D2-A50C-19202320AB32"> <p class="notep1">Note:</p>This parameter is deprecated and will be removed in a future release. </div><p>The comma-separated HTTP request methods (such as GET or POST). Default GET. </p>

Examples

This example enables myschema.mypkg.proc to be called via GET and POST requests, such as https://www.example.com/apex/myschema.mypkg.proc

BEGIN
    apex_instance_admin.add_web_entry_point (
        p_name    => 'MYSCHEMA.MYPKG.PROC',
        p_methods => 'GET,POST' );
    COMMIT;
END;