Access Procedure from URL

To access your procedure from the URL, make sure you grant EXECUTE privileges to APEX_PUBLIC_USER by running the command

GRANT EXECUTE ON <PROCEDURE_NAME> TO APEX_PUBLIC_USER;

The URL should be like http://server_name/apex/<schema_name>.<procedure_name>.

If you also have some parameters to pass, the URL should be like http://server_name/apex/<schemaname>.<procedurename>?<PARAMETER1=VALUE>&<PARAMETER2=VALUE>.

Also if you are a DedicatedDB client please make sure the following line is removed from the ORDS configuration:

<entry key="security.requestValidationFunction">wwv_flow_epg_include_modules.authorize</entry>

  • 7 Users Found This Useful
Was this answer helpful?

Related Articles

Connect to Database with Toad/SQL Developer etc

The Welcome Email you receive when you place an order contains Host name, port, database name,...

Import Data

Step-by-Step Guide for Importing Dump File Step 1: Ensure the Dump File is Accessible...

Data Export / Backup

You can export your data with the EXP utility provided by Oracle. The command should be like the...

Scheduled Jobs

With our shared hosting plans you are allowed to run a scheduled job maximum 4 times a day and...

Get Client IP Address

To get the IP address of your client accessing the Apex application through the browser you can...