Hello, when i am trying to set the variable plsql_debug=TRUE using the command
alter package package_name compile BODY plsql_debug=TRUE reuse settings ;
through PUTTY, the changes are getting reflected in the database, and can view the same using the SQL developer,
but when I compile the packege again through PUTTY using the command:
alter package package_name compile BODY;
The change gets revert, the value of plsql_debug in the table ‘USER_PLSQL_OBJECT_SETTINGS’ becomes FALSE.
How to make it permanent, so that its value does not get changed after every cmpilation…
I am using oracle 11g as database and PUTTY on Linux.