SQL Developer (MOSC)

MOSC Banner

BUGs in SQL Developer (since version 19 and persisting into v24.3.1) with TRAILING SPACES / BLANKS

FYI for everybody using SQL Developer, in the SQL Worksheet where you submit queries or DML or DDL statements against your current database connection:

BUG #1: If you try to execute a single DESCRIBE statement for any owner.object, with one or more TRAILING BLANKS (SPACES) AFTER the object name, you will get an ORA-04043 "object does not exist" error. If you REMOVE ALL TRAILING BLANKS (SPACES) after the object-name, the DESCRIBE statement will describe that object correctly WITHOUT error (as long as the object actually does exist).

Test case: "DESCRIBE SCOTT.EMP " — without the quotes, but WITH one or more TRAILING BLANKS.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center