Toad World® Forums

How to make plsql_debug value in 'USER_PLSQL_OBJECT_SETTINGS' permanent?

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.

Regards
Neo_V