SQL Developer Does Not Show Breakpoint Option While Debugging Anonymous PL/SQL Block of Code Against 12c Database (Doc ID 2434928.1)

Last updated on MAY 29, 2023

Applies to:

Symptoms

SQL Developer is not showing option to set break point while debugging an anonymous Pl/SQL block.

It works fine on a stored procedure or package with 12c database.

For Example:

Debugger starts, but

• No “Anonymous PL/SQL” block opened.
• No option to set the break point.
• Debug Icons shows only one of them enabled.

So, it does not allow to set break point and debug.

Database 11g Example:

SQL Developer while connected to 11g ( and lower) database:

Debugger starts and shows

•  “Anonymous PL/SQL” block opened.
• Option to set the break point.
• Debug Icons shows All enabled.

Changes

 12c database is in use.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.