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.