This discussion is archived
2 Replies Latest reply: Mar 4, 2013 8:55 AM by Cherif bh RSS

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

3004 Newbie
Currently Being Moderated
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.