today:
131
yesterday:
179
Total:
1,001,227

General APEX Web Services Proxy Settings

admin 2016.06.07 14:48 Views : 351

  • https://community.oracle.com/thread/1382356?tstart=0
  • the web services call will be made by the database server, so authentication isn't just an issue for APEX, but you would give the host running the database server access.
    APEX itself only supports the simple proxy case just to provide the basic functionality.
    Depending on which web server you use to host APEX, you might be able to let that host pass your proxy attributes with the request (e.g. when using OHS, you could put the values into PlsqlCGIEnvironmentList), though I'm not sure whether they are forwarded for web service requests automatically or if you have to build your own process to extract the value from the CGI environment and add it to the web service call.
    Another option could be to start building the process in your own process right away. The database has the API-package UTL_HTTP which can be used to perform the proxy authentication (utl_http.set_authentication with for_proxy => true)
    Have a look on these pages:
    - example for a request including proxy and authentication (with the little change to be "for proxy") http://www.oracle.com/technology/sample_code/tech/pl_sql/htdocs/x/Utl_Http_Package_Enhancements/Cr_Using_Utl_Http.htm
    - a nice overview on the package methods: http://psoug.org/reference/utl_http.html
No. Subject Author Date Views
126 LAST DAY SQL admin 2024.01.19 114
125 Null Display Value admin 2024.01.10 111
124 영수증 2023 file admin 2024.01.04 222
123 Column Data 일괄 추가 admin 2023.11.24 129
122 Using SQL*Plus to Unlock and Change Passwords admin 2023.06.04 150
121 Reversing Require HTTPS admin 2023.06.04 84
120 ipconfig admin 2023.06.03 67
119 127.0.0.1:8080/apex/ admin 2023.06.03 83
118 CHANGE TABLE NAME admin 2023.05.31 58
117 DATE -> DAY CONVERT SQL admin 2023.05.25 38
116 YEAR EXPRESSIONS admin 2023.05.25 34
115 GRAPH (BAR) SQL SAMPLE admin 2023.05.25 39
114 Monthly SUM admin 2023.05.22 37
113 INNER JOIN admin 2023.05.19 37
112 LOOP TABLE UPDATE admin 2023.05.19 50
111 Global pages admin 2023.05.09 40
110 ORACLE COLLECTION admin 2023.05.08 38
109 FINAL TEST admin 2023.05.08 44
108 GitHub.com/Oracle/APEX. admin 2023.05.04 40
107 TEST admin 2023.05.03 36