get the full path of a the currently executing script

[goaway1234]

I am charged with reviewing our change management procedures at my company. We already have a database script template that records bug/issue information when a script is run (just a few lines of code saved above the actual changes), and I would like to expand this information to include the file path of the updaate script.

Does anybody know whether it is possible to write a function that will return the path of the currently executing file (if any). The goal is that if in sql*plus, the user types @ C:\scripts\XXX.sql then the function returns 'c:\scripts\XXX.sql'.

 

[johnherman]

In the unix world, there is a "which" command. In Windows, there is no equivalent, although there are cheap and free Unix lookalikes which can be installed on Windows.

http://www.mkssoftware.com,

http://www.freebsd.org,

http://www.datafocus.com

-------------------------
The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright