Error applying automatic debug information mode

[sam]

When ever user tried to login, gets the above message and tells that user needs alter session privilege. And user does have that system privilege.

Version 5.0.2.500 - PL/SQL developer.

Please let me know, so that debug utility can be used effectively and efficiently.

Thanks,

 

[Marco Kalter]

Can you try the following statement in a SQL Window for this user:

alter session set plsql_debug=true

Let me know how this turns out.

------------------
Marco Kalter
Allround Automations

 

[Wayne Essel]

Hi.

I Have the same problem on login. I tried the fix and here's the error message that subsequently displayed:

"Insufficient Priviledges"

Is the "plsql_debug=true" an environmental value? Or is there an add-in that actually recognizes PL/SQL Developer?

 

[Marco Kalter]

The "alter session set plsql_debug=true" statement is a standard sql statement. It does however require the "alter session" system privilege.

You can either obtain this privilege, or disable the "Add debug information when compiling" preference (Tools > Preferences > Debugger tab page). When this preference is disabled, you can only view and set variable values in the debugger when you explicitly add debug information by right-clicking on the corresponding program unit and selecting "Add debug information" from the popup menu.