Skip to Main Content

Oracle Database Discussions

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!

SP2-0423: Illegal GET command (... solution ...)

Steve CosnerApr 28 2016 — edited Apr 29 2016

Using SQL Plus Release 10.2.0.3.0 on Windows, trying to do a File, Open on a simple .sql file, I was getting that error:

SP2-0423: Illegal GET command

Doing a web search turned up a discussion from 2009, but the issue was not resolved there.  Finally found it in an older thread.  Thought I would post here so that maybe new searches will lead people to the answer more quickly:

SQL Plus on Windows hates file and directory names with spaces.   Even though Windows allows it, SQL Plus throws the error:

SP2-0423: Illegal GET command

The solution:  Remove spaces from file and directory names.   I either compress the names, or use an underscore where spaces might be.

I use the File, Open all the time as a backdoor cd (Change Directory) command.  That is a primary reason I cling to the old sqlplusw.exe.

If anyone can show me a way to get the newer sqlplus.exe (version 11.2.0.2.0 for example), to dynamically change its primary directory, then I could retire this old stuff!   The only way I know to do it is to change the "Start in:" directory on a specifically built Windows Shortcut.  And that solution stinks.  Note that sqlplus.exe does NOT even offer the File, Open tool that sqlplusw uses.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 27 2016
Added on Apr 28 2016
3 comments
1,080 views