Skip to Main Content

SQL & PL/SQL

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-0116: Illegal SAVE command after setting 'editfile' in SQLPLUS

GusoraJun 8 2015 — edited Jun 8 2015

define _editor = notepad.exe

set editfile "C:\Users\xxxxx\Google Drive\Oracle\SQL Scripts\myBufferFile.sql"

orcl > select user from dual;

USER

------------------------------

CODD

orcl > ed

SP2-0116: Illegal SAVE command

orcl > select user from dual;

I have started SQLPLUS in administrator mode but to no avail, have created the empty file 'myBufferFile.sql' by hand, the path above is correct and was checked. Commenting the 'editfile' line out everything resumes to normal service. What am I doing wrong here?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 6 2015
Added on Jun 8 2015
9 comments
1,027 views