24.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

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)	Note: This parameter is deprecated and will be removed in a future release. The comma-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;