22.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 |
---|---|
|
The procedure name, prefixed by package name and schema, unless a public synonym exists. |
|
The comma-separated |
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