Skip to Main Content

SQL Developer for VS Code

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!

EXEC Command Fails When Preceded by Leading Whitespace. [SQL dev for VSC]

When I execute a procedure using the EXEC command, a leading space before EXEC causes the command to fail with an error instead of being executed.

set serveroutput on
create or replace procedure test is
begin
   dbms_output.put_line ('Hello world');
end;
/

SQL Developer

VS Code


BEGIN te; END;
      *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'TE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
https://docs.oracle.com/error-help/db/ora-06550/
More Details :
https://docs.oracle.com/error-help/db/ora-06550/
https://docs.oracle.com/error-help/db/pls-00201/

If I highlight/select the command and execute only the selected text, it runs correctly even with leading whitespace.

This post has been answered by thatJeffSmith-Oracle on Jun 2 2026
Jump to Answer
Comments
Post Details
Added 5 days ago
4 comments
31 views