OWA_SEC Functions Do Not Return Anything or Fail with ORA-01403 Error
(Doc ID 743891.1)
Last updated on OCTOBER 05, 2018
Applies to:Oracle HTTP Server - Version: 188.8.131.52 to 184.108.40.206.0
This problem can occur on any platform.
When mod_plsql Basic authentication is used, calling the following OWA_SEC functions:
does not return anything.
Furthermore, owa_sec.get_client_ip fails with an ORA-01403 error.
Errors similar to the following are displayed in the HTTP Server error_log file:
[Thu Sep 25 22:17:12 2008] [notice] [client 220.127.116.11] [ecid: 1222373832:18.104.22.168:2280:3244:2,0]
mod_plsql: ORA-1403 Execute ORA-01403: no data found
ORA-06512: at "MYSCHEMA.MYPACKAGE", line 8
ORA-06512: at line 25
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.|