Can I set nls_date_format in SQLDeveloper debugger?

maldrich12

I have it set in Tools -> Preferences -> Database -> NLS, but that does not work in debug mode.

thatJeffSmith-Oracle

switch over to dbms_debug in preferences and the new db session will adopt whatever settings you have going in SQLDev.

JDWP doesn't actually do a new db session from SQLDev to the DB.

thatJeffSmith-Oracle

Then that would be a bug...

And yes, put the alter session in your anon block for the stored procedure

maldrich12

Thanks, but I am looking for a global option where I do not have to do that for each stored procedure.

thatJeffSmith-Oracle

debug mode - which debugger are you using?

dbms_debug or jdwp ?

maldrich12

jdwp, I think. Just using the debug icon in sqldev.

thatJeffSmith-Oracle

switch over to dbms_debug in preferences and the new db session will adopt whatever settings you have going in SQLDev.

JDWP doesn't actually do a new db session from SQLDev to the DB.

maldrich12

I am not seeing that in my Preferences. Using Version 19.2.1.247

Under Preferences -> Debugger -> Breakpoints, there is a drop down for Debugger, but the only option is 'Java Debugger'.

maldrich12

Downloaded V21 and can make the change. Thanks a lot.