today:
24
yesterday:
135
Total:
997,813

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
106 TEST admin 2023.04.28 40
105 WHDR email address admin 2023.04.13 55
104 TEST admin 2023.03.27 97
103 GP 영수증 (3) -01/04/2023 admin 2023.01.04 53
102 GP - 영수증 (2) admin 2022.11.07 63
101 GP 영수증 본문 admin 2022.11.07 61
100 STARTUP admin 2022.09.01 83
99 SQL Developer Password change / EXPORT & IMPORT admin 2022.03.18 157
98 Forgot Oracle username and password, how to retrieve? admin 2022.03.18 151
97 SQL DEVELOPER file admin 2022.03.17 106
96 How to Install Oracle 11g on Windows 10 - 64 bit | Download / Install Oracle 11g Database file admin 2022.03.17 120
95 QRCODE admin 2020.05.25 405
94 JK admin 2019.02.05 700
93 ACTION admin 2019.01.11 6454
92 SELECT last_name FROM admin 2018.12.12 742
91 IMP admin 2018.10.08 717
90 CREATE TABLE admin 2018.09.25 471
89 Change Admin PASSWORD admin 2018.07.31 225
88 VERY IMPORTANT admin 2018.06.26 224
87 IF/ELSE ... CASE WHEN admin 2018.06.25 208