ADD_WEB_ENTRY_POINT Procedure

32.4 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;

Parent topic: APEX_INSTANCE_ADMIN