This content has been marked as final. Show 6 replies
So, you're using Application Server?
Perhaps this is of use then:
"These authorize functions work in OAS, but do not work in 9iAS 1.0.2. When
such a function is used this error message will be printed to the HTML page:
Custom Authentication Failure. [testauth.authorize] oerr = 1405
ORA-01405: fetched column value is NULL
To make the authorize function work again in mod_plsql change it to look like
function authorize return boolean is
owa_sec.set_protection_realm ('Dummy Realm');
This means that You must specify a realm name in Your authorize functions
for mod_plsql while You didn't have to when using OAS."
I'd like to point you to a more recent article, but for some reason Metalink keeps on crashing my browser at the moment....
Yes, using Oracle OHS .... though the same system has been working for years and we have dozens of databases, all running the same application on the same single OHS with no issue
removing the OHS from the equation I can't compile the procedure from sqlplus so it can't be an issue with the OHS. The issue only started last week, someone must have changed something in the database but I can't find out what. Comparing users it doesn't look like a missing user
SQL> SQL> alter procedure database_anal_alert compile; alter procedure database_anal_alert compile * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-01405: fetched column value is NULL SQL> create or replace procedure database_anal_alert 2 as 3 begin 4 null; 5 end; 6 / create or replace procedure database_anal_alert * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-01405: fetched column value is NULL SQL> drop procedure Procedure dropped. SQL> create or replace procedure database_anal_alert 2 as 3 begin 4 null; 5 end; 6 / Procedure created.