I created a policy function
create or replace function party_sec(
p_schema varchar2,
p_obj varchar2
) return varchar2 as
l_database_user varchar2(255) DEFAULT USER;
l_predicate varchar2(100);
begin
if SYS_CONTEXT('APEX$SESSION', 'APP_USER') = ('DEVELOPER') then
l_predicate := 'ID in (select MANDAT from H_PARTY)';
end if;
return l_predicate;
end;
It is working with about 40 values in the in clause but when I use the whole table with 289 values
I got the message
Error at line 1/15: ORA-28113: policy predicate has error