Access Procedure from URL

To access your procedure from URL, make sure you grant EXECUTE privileges to APEX_PUBLIC_USER. The URL should be like http://server_name/apex/schemaname.procedurename<schema_name.procedure_name> . If you also have some parameters to pass, the URL should be like <schema_name.procedure_name>http://server_name/apex/schemaname.procedurename?<parameter1=value><&PARAMETER2=VALUE>

Also if you are a DedicatedDB client you have to remove/modify following lines in ORDS configuration:

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

  • 5 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

You can import your data with IMP utility provided by Oracle. The import command should be like...

Data Export / Backup

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

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 browser you can use...

Powered by WHMCompleteSolution