Hi,

I was wondering. Is it possible to get SqlPlus to search for scripts
in multiple directories?

Ive found advice for setting the directory in the login.sql file for a
single directory reference but not a reference on how to set multiple
directories using SQLPATH.

I have scripts spread across several subdirects. off a root directory.
I would like sqlplus to read for the named script file in the subdirects., this way I dont have to type in lengthy directory strings before the
name of the script file in a sqlplus.

In short, Im trying to run, using START, script files from script files.

Any advice would be greatly appreciated.

ps
Would be better attempted using PL/SQL and if so, is there a site
that gives sample procedures?