My Oracle Support Banner

ED Command In SQLPLUS Does Not Pickup SQLPATH Variable (Doc ID 563615.1)

Last updated on OCTOBER 28, 2016

Applies to:

SQL*Plus - Version: and later   [Release: Oracle10g and later ]
Information in this document applies to any platform.


Setting the SQLPATH environment variable has no effect in a new install of SQL*Plus client.

Steps to Reproduce the problem:
1. Set SQLPATH in registry to a local or network drive.
2. Start SQL*Plus client.
3. Connect to any database.
4. Type: ed <script_name> (ensure the specified .sql file exists in the path specified for SQLPATH).
5. Press Enter.

The user will be displayed with the following:

File cannot be found and options include to create a file with <script_name>.

@<script name> works as expected.


Upgrade of SQL*Plus client to


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.