SQLcl: MCP Server & SQL Prompt

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!

possible bug (minor) : SQL Error: ORA-00904 when empty new line in sqlcl query

zakiH2 days ago — edited 2 days ago

SQL> select 
 2  empno,
 3  ename
 4  from emp
 5* ;
  EMPNO ENAME     
________ _________ 
   7839 KING      
   7698 BLAKE     
   7782 CLARK     
   7566 JONES     
   7788 SCOTT     
   7902 FORD      
   7369 SMITH     
   7499 ALLEN     
   7521 WARD      
   7654 MARTIN    
   7844 TURNER    
   7876 ADAMS     
   7900 JAMES     
   7934 MILLER    
14 rows selected.

select 
 2  empno,
 3  ename
 4  
 5  from emp
 6* ;
Error starting at line : 1 in command -
select 
empno,
ename
Error at Command Line : 3 Column : 1
Error report -
SQL Error: ORA-00904: "ENAME": invalid identifier
https://docs.oracle.com/error-help/db/ora-00904/00904. 00000 -  "%s: invalid identifier"
*Cause:    The identifier or column name entered was invalid.
*Action:   Ensure the following
More Details :
https://docs.oracle.com/error-help/db/ora-00904/
Error starting at line : 1 in command -
from emp
Error report -
Unknown Command
 1  select 
 2  empno,
 3* ename


Oracle SQLDeveloper Command-Line (SQLcl) version: 25.2.2.0 build: 25.2.2.199.0918
                                                
__________________________________________________________________________________ 
Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.9.0.25.07

java -version
openjdk version "21.0.8" 2025-07-15
OpenJDK Runtime Environment (build 21.0.8+9-Ubuntu-0ubuntu124.04.1)
OpenJDK 64-Bit Server VM (build 21.0.8+9-Ubuntu-0ubuntu124.04.1, mixed mode, sharing)

Added 2 days ago

#sqlcl

1 comment

27 views

1 mention