2 Replies Latest reply: Mar 4, 2013 10:55 AM by Cherif bh RSS

    ORA-01031:Insufficient Privileges (line 32) executing SYS.DBMS_SESSION.SET_SQL_TRACE

    3004
      I'm getting ORA-01031:Insufficient Privileges (line 32) executing SYS.DBMS_SESSION.SET_SQL_TRACE when I call it from within a package I have written.

      I have granted my user account EXECUTE priv on DBMS_SESSION, and can execute the SET_SQL_TRACE procedure successfully from the SQL prompt. It just can't get it to work when calling it from within the package.
      Since the source is wrapped, I can't find out what privilege is missing.
      I'm running Oracle 7.3.4.