Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Plus use limit

Status
Not open for further replies.

stressman

Programmer
Jan 4, 2002
48
FR
I saved my most used scripts in files and i was used to execute a script in server manager by the way of
@<Directory Way>/ScriptName.sql

When i learned that server manager is no more supported by oracle 10g, i decided to use SQL Plus.

Problem : sometimes the execution of
@<Directory Way>/ScriptName.sql

simply kill the SQLPlus session. I find out the it was due to a too long "Directory Way"

Is there a parameter which will enable me to use a long path name to execute a script.
I hope that this message is clear enough and that such a parameter exist.

thanks for your help
 
Have tried assigning your path to a variable and using that. Something like:

export longpath=<long path name in full>

Then use this from the SQL prompt:

@$longpath/script.sql

Hope this helps.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top