This discussion is archived
3 Replies Latest reply: Sep 24, 2012 3:36 AM by Harm Joris ten Napel RSS

ORA-28112 while testing FGA

963842 Newbie
Currently Being Moderated
Hi gurus
I'm testing the FGA and getting below error.
ORA-28112: policy function or package HR.POLICY_FUNC has error

What may be the reason for it, some time ago it was working.
  • 1. Re: ORA-28112 while testing FGA
    KuljeetPalSingh Guru
    Currently Being Moderated
    what trace file saying

    28112, 00000, "failed to execute policy function"
    // *Cause: The policy function has one or more error during execution.
    // *Action: Check the trace file and correct the errors.                                                                                                                                                                                                                                                                                                                                                                                                                           
  • 2. Re: ORA-28112 while testing FGA
    921598 Explorer
    Currently Being Moderated
    ORA-28112 results if SELECT or DML is performed on a table with an associated policy function and the policy function has policy-related errors.
    Check your policty function , is it in "valid" status?

    Regards
    Inam Bukhari
    http://dbmentors.blogspot.com
  • 3. Re: ORA-28112 while testing FGA
    Harm Joris ten Napel Pro
    Currently Being Moderated
    Hi

    unfortunately this error from the support perspective is usually classified as a 'user error' :) but of course
    we can help you find the cause, there are some troubleshooting references in MOS here:

    How To Diagnose Error ORA-28112 (Doc ID 751850.1)
    How To Resolve ORA-28110 or ORA-28112 On SELECT Or DML (Doc ID 69401.1)

    Another simple test I recommend is to execute the policy predicate function independently
    and see if the value it returns makes any sense, so any issues may become clear:

    select HR.POLICY_FUNC('user','object') from dual;

    Please note we are currently actively promoting the new support communities also, so if you want to get some
    feedback from your peers as well as the attention of Oracle support engineers, please go to

    https://communities.oracle.com/portal/server.pt/community/database_security_products/338

    This will put you in the Database Products Security community , but you can select others also from the left,

    Greetings,

    Harm ten Napel
    Oracle Support

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points