edit command on sql*plus

[Chrissirhc]

Hi when I type ed on the sql*plus command prompt I expect to see the last select statement I typed in the editor of my choice (notepad).

Instead I get the error

" SP2-0110: Cannot create save file "afiedt.buf" "

How do I fix this?

Thanks in advance,

Chris

 

[sem]

In fact sql*plus saves the last command in the file afiedt.buf and then opens this file in your editor. Thus you need to be permited to write to the directory you started sql*plus from. Regards, Dima

 

[Chrissirhc]

Thanks,

You can go to options --> environment .

And change the settings for where the buffer is saved. I saved it to a different drive and it works fine.

Thanks for your help.