My Oracle Support Banner

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: 9.0.4.0 to 11.1.1.0.0
This problem can occur on any platform.

Symptoms

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 141.144.137.102] [ecid: 1222373832:141.144.137.102: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

Cause

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
  Symptoms
  Cause
  Solution
  References

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.

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