SQL plus

[learning_plsql]

if you want to run the file with a long path, what do you need to set before you run the file???

for example:

@C:\scripts\mytest_3.0.1\VERSION_100_1001\lease_affective_day\clean_up_old customers_as_require.sql

thanks all

[learning_plsql]

Could someone help me to answer this question????

thanks a bunch

[mrchrispy]

TBH i ont understand the question.
didn't you answer it yourself with the example?

[learning_plsql]

no, when I can't run that scripts b/c I got some kind of errors and I copy and paste it in SQL*PLUS. I guess the path is too long.

[davey23uk]

what erros do you get

[learning_plsql]

string beginning "C:\scripts..." is too long. maximum size is 79 characters.

[jmodic]

According to your script's path I assume you use Window's version of SQL*Plus. If so, you could implicitly set the current working directory by opening any file (it doesn't have to be "clean_up_old_customers_as_require.sql", any file from that directory will do). So in menu "File" click "Open" and then chhose any file from that directory. At the last line of opened file you enter dot (character ".") to close that file. Now your working directory is set and you can start your script by simply enetering it's name:

@clean_up_old_customers_as_require.sql

[jmodic]

I just noticed you have a space in your file name:

clean_up_old customers_as_require.sql

I hope this is not a typo and your real file name is

clean_up_old_customers_as_require.sql

If not, you better enclose that filename in double quotes!

[learning_plsql]

Jmodic,

SOrry, it's typo and there should be underscore instead of the space between.

[mrchrispy]

ah.....I get you now.

have you tried using env variables?

actually that don't work either, I've just tried. I even managed to kill SQLplus

windowsXP (my laptop) - oracle 8.1.7.0.
1. create 2 directories - one with a long dir name and one short.
2. log into SQLplus and verify that you can run a script in the short dir and that one in the long dir name fails.
3. exit and set some environment variables with the pathnames for the 2 directories (eg %LONG% and %SHORT%).
4. back into SQLplus and try running the same files but use the variables.
i.e.
>@\test\%SHORT%\test.sql and
>@\test\%LONG%\test.sql

the short one should work but the long doesn't even return the "maximum size is 79 characters." error but bombs SQLplus.

completely pointless experiment but at least it distracted me for a while

you could navigate upto the dir you what so the string is less that the 79 character limit (eg >$cd \bla\nearly_there\bla) . ugly but it'll work