20.3 ADD_WEB_ENTRY_POINT Procedure

Purpose

Add a public procedure to the white list of 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

PROCEDURE 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	The colon-separated HTTP request methods (such sa GET, POST). Default GET.

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;