My Oracle Support Banner

OWA_SEC Functions Do Not Return Anything or Fail with ORA-01403 Error (Doc ID 743891.1)

Last updated on AUGUST 19, 2019

Applies to:

Oracle HTTP Server - Version to [Release AS10g to Oracle11g]
Information in this document applies to any platform.
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:

[date time] [notice] [client <ip>] [ecid: <ecid>]
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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.