Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can I set nls_date_format in SQLDeveloper debugger?

maldrich12Aug 21 2021

I have it set in Tools -> Preferences -> Database -> NLS, but that does not work in debug mode.
This post has been answered by thatJeffSmith-Oracle on Mar 22 2022
Jump to Answer

Comments

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
Answer

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.

Marked as Answer by maldrich12 · Mar 22 2022
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.

1 - 7

Post Details

Added on Aug 21 2021
#sql-developer
7 comments
274 views