Getting the name of currently executing sql script in sql*plus

  • From: Srinivas Chintamani <srinivas.chintamani@xxxxxxxxx>
  • To: Oracle L <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 4 Dec 2009 22:39:50 -0500

Hi Listers,
Is there any way to get the name of the current script being executed by
sql*plus?

For example..
I have the following levels of scripts ...

1. Driver_Script.sql calls
2.....one.sql and
3.....two.sql
4.....three.sql which calls
5............four.sql and
6............five.sql.

What I want to be able to do is within each one of those scripts, "Get" the
name of the script being executed.  Is it possible to do this?

-- 
Regards,
Srinivas Chintamani

Other related posts: