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:
Last edited by jmodic; 04-15-2004 at 10:13 AM.
Jurij Modic ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
actually that don't work either, I've just tried. I even managed to kill SQLplus
windowsXP (my laptop) - oracle 188.8.131.52.
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.
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